﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="AutoFixDataSet" targetNamespace="http://tempuri.org/AutoFixDataSet.xsd" xmlns:mstns="http://tempuri.org/AutoFixDataSet.xsd" xmlns="http://tempuri.org/AutoFixDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="AutoFix_FinalConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="AutoFix_FinalConnectionString1 (Settings)" PropertyReference="ApplicationSettings.DataDefinition.Properties.Settings.GlobalReference.Default.AutoFix_FinalConnectionString1" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ApplicationUserTableAdapter" GeneratorDataComponentClassName="ApplicationUserTableAdapter" Name="ApplicationUser" UserDataComponentName="ApplicationUserTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="ApplicationUser" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ApplicationUser` WHERE ((`UserID` = ?) AND ((? = 1 AND `FirstName` IS NULL) OR (`FirstName` = ?)) AND ((? = 1 AND `LastName` IS NULL) OR (`LastName` = ?)) AND ((? = 1 AND `EmailAddress` IS NULL) OR (`EmailAddress` = ?)) AND ((? = 1 AND `UserName` IS NULL) OR (`UserName` = ?)) AND ((? = 1 AND `Password` IS NULL) OR (`Password` = ?)) AND ((? = 1 AND `ProfilePictureURL` IS NULL) OR (`ProfilePictureURL` = ?)) AND ((? = 1 AND `City` IS NULL) OR (`City` = ?)) AND ((? = 1 AND `Country` IS NULL) OR (`Country` = ?)) AND ((? = 1 AND `PhoneNumber` IS NULL) OR (`PhoneNumber` = ?)) AND ((? = 1 AND `UserTypeID` IS NULL) OR (`UserTypeID` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FirstName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_FirstName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_LastName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_LastName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EmailAddress" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EmailAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EmailAddress" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EmailAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UserName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Password" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Password" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ProfilePictureURL" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProfilePictureURL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ProfilePictureURL" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ProfilePictureURL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_City" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Country" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Country" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PhoneNumber" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PhoneNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PhoneNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PhoneNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ApplicationUser` (`FirstName`, `LastName`, `EmailAddress`, `UserName`, `Password`, `ProfilePictureURL`, `City`, `Country`, `PhoneNumber`, `UserTypeID`, `IsActive`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="FirstName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="LastName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EmailAddress" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EmailAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UserName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Password" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ProfilePictureURL" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ProfilePictureURL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Country" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PhoneNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PhoneNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT UserID, FirstName, LastName, EmailAddress, UserName, [Password], ProfilePictureURL, City, Country, PhoneNumber, UserTypeID, IsActive FROM ApplicationUser</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ApplicationUser` SET `FirstName` = ?, `LastName` = ?, `EmailAddress` = ?, `UserName` = ?, `Password` = ?, `ProfilePictureURL` = ?, `City` = ?, `Country` = ?, `PhoneNumber` = ?, `UserTypeID` = ?, `IsActive` = ? WHERE ((`UserID` = ?) AND ((? = 1 AND `FirstName` IS NULL) OR (`FirstName` = ?)) AND ((? = 1 AND `LastName` IS NULL) OR (`LastName` = ?)) AND ((? = 1 AND `EmailAddress` IS NULL) OR (`EmailAddress` = ?)) AND ((? = 1 AND `UserName` IS NULL) OR (`UserName` = ?)) AND ((? = 1 AND `Password` IS NULL) OR (`Password` = ?)) AND ((? = 1 AND `ProfilePictureURL` IS NULL) OR (`ProfilePictureURL` = ?)) AND ((? = 1 AND `City` IS NULL) OR (`City` = ?)) AND ((? = 1 AND `Country` IS NULL) OR (`Country` = ?)) AND ((? = 1 AND `PhoneNumber` IS NULL) OR (`PhoneNumber` = ?)) AND ((? = 1 AND `UserTypeID` IS NULL) OR (`UserTypeID` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="FirstName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="LastName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EmailAddress" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EmailAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UserName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Password" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ProfilePictureURL" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ProfilePictureURL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Country" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PhoneNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PhoneNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FirstName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_FirstName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_LastName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_LastName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EmailAddress" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EmailAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EmailAddress" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EmailAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UserName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Password" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Password" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ProfilePictureURL" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ProfilePictureURL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ProfilePictureURL" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ProfilePictureURL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_City" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Country" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Country" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PhoneNumber" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PhoneNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PhoneNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PhoneNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="EmailAddress" DataSetColumn="EmailAddress" />
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="ProfilePictureURL" DataSetColumn="ProfilePictureURL" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="PhoneNumber" DataSetColumn="PhoneNumber" />
              <Mapping SourceColumn="UserTypeID" DataSetColumn="UserTypeID" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ApplicationUserTypeTableAdapter" GeneratorDataComponentClassName="ApplicationUserTypeTableAdapter" Name="ApplicationUserType" UserDataComponentName="ApplicationUserTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="ApplicationUserType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ApplicationUserType` WHERE ((`UserTypeID` = ?) AND ((? = 1 AND `UserType` IS NULL) OR (`UserType` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UserType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ApplicationUserType` (`UserType`, `IsActive`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UserType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT UserTypeID, UserType, IsActive FROM ApplicationUserType</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ApplicationUserType` SET `UserType` = ?, `IsActive` = ? WHERE ((`UserTypeID` = ?) AND ((? = 1 AND `UserType` IS NULL) OR (`UserType` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UserType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UserType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserTypeID" DataSetColumn="UserTypeID" />
              <Mapping SourceColumn="UserType" DataSetColumn="UserType" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ArticleTableAdapter" GeneratorDataComponentClassName="ArticleTableAdapter" Name="Article" UserDataComponentName="ArticleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="Article" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Article` WHERE ((`ArticleID` = ?) AND ((? = 1 AND `ArticleName` IS NULL) OR (`ArticleName` = ?)) AND ((? = 1 AND `ArticleImageUrl` IS NULL) OR (`ArticleImageUrl` = ?)) AND ((? = 1 AND `ArticleTypeID` IS NULL) OR (`ArticleTypeID` = ?)) AND ((? = 1 AND `VehicleModelID` IS NULL) OR (`VehicleModelID` = ?)) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `VehicleModelTypeID` IS NULL) OR (`VehicleModelTypeID` = ?)) AND ((? = 1 AND `VehicleModelTypeYearID` IS NULL) OR (`VehicleModelTypeYearID` = ?)) AND ((? = 1 AND `LastUpdatedDate` IS NULL) OR (`LastUpdatedDate` = ?)) AND ((? = 1 AND `IsPublished` IS NULL) OR (`IsPublished` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ArticleName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleImageUrl" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleImageUrl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ArticleImageUrl" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleImageUrl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelTypeYearID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeYearID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelTypeYearID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeYearID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_LastUpdatedDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="LastUpdatedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_LastUpdatedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastUpdatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsPublished" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsPublished" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsPublished" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsPublished" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Article` (`ArticleName`, `ArticleImageUrl`, `ArticleTypeID`, `VehicleModelID`, `UserID`, `VehicleModelTypeID`, `VehicleModelTypeYearID`, `LastUpdatedDate`, `IsPublished`, `IsActive`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ArticleName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ArticleImageUrl" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleImageUrl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ArticleTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="VehicleModelTypeYearID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeYearID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="LastUpdatedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastUpdatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsPublished" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsPublished" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ArticleID, ArticleName, ArticleImageUrl, ArticleTypeID, VehicleModelID, UserID, VehicleModelTypeID, VehicleModelTypeYearID, LastUpdatedDate, IsPublished, IsActive FROM Article</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Article` SET `ArticleName` = ?, `ArticleImageUrl` = ?, `ArticleTypeID` = ?, `VehicleModelID` = ?, `UserID` = ?, `VehicleModelTypeID` = ?, `VehicleModelTypeYearID` = ?, `LastUpdatedDate` = ?, `IsPublished` = ?, `IsActive` = ? WHERE ((`ArticleID` = ?) AND ((? = 1 AND `ArticleName` IS NULL) OR (`ArticleName` = ?)) AND ((? = 1 AND `ArticleImageUrl` IS NULL) OR (`ArticleImageUrl` = ?)) AND ((? = 1 AND `ArticleTypeID` IS NULL) OR (`ArticleTypeID` = ?)) AND ((? = 1 AND `VehicleModelID` IS NULL) OR (`VehicleModelID` = ?)) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `VehicleModelTypeID` IS NULL) OR (`VehicleModelTypeID` = ?)) AND ((? = 1 AND `VehicleModelTypeYearID` IS NULL) OR (`VehicleModelTypeYearID` = ?)) AND ((? = 1 AND `LastUpdatedDate` IS NULL) OR (`LastUpdatedDate` = ?)) AND ((? = 1 AND `IsPublished` IS NULL) OR (`IsPublished` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ArticleName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ArticleImageUrl" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleImageUrl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ArticleTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="VehicleModelTypeYearID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeYearID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="LastUpdatedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastUpdatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsPublished" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsPublished" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ArticleName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleImageUrl" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleImageUrl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ArticleImageUrl" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleImageUrl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelTypeYearID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeYearID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelTypeYearID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeYearID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_LastUpdatedDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="LastUpdatedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_LastUpdatedDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastUpdatedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsPublished" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsPublished" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsPublished" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsPublished" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ArticleID" DataSetColumn="ArticleID" />
              <Mapping SourceColumn="ArticleName" DataSetColumn="ArticleName" />
              <Mapping SourceColumn="ArticleImageUrl" DataSetColumn="ArticleImageUrl" />
              <Mapping SourceColumn="ArticleTypeID" DataSetColumn="ArticleTypeID" />
              <Mapping SourceColumn="VehicleModelID" DataSetColumn="VehicleModelID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="VehicleModelTypeID" DataSetColumn="VehicleModelTypeID" />
              <Mapping SourceColumn="VehicleModelTypeYearID" DataSetColumn="VehicleModelTypeYearID" />
              <Mapping SourceColumn="LastUpdatedDate" DataSetColumn="LastUpdatedDate" />
              <Mapping SourceColumn="IsPublished" DataSetColumn="IsPublished" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ArticleRatingTableAdapter" GeneratorDataComponentClassName="ArticleRatingTableAdapter" Name="ArticleRating" UserDataComponentName="ArticleRatingTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="ArticleRating" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ArticleRating` WHERE ((`ArticleID` = ?) AND ((? = 1 AND `Rating` IS NULL) OR (`Rating` = ?)) AND (`UserID` = ?) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Rating" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Rating" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ArticleRating` (`ArticleID`, `Rating`, `UserID`, `IsActive`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Rating" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ArticleID, Rating, UserID, IsActive FROM ArticleRating</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ArticleRating` SET `ArticleID` = ?, `Rating` = ?, `UserID` = ?, `IsActive` = ? WHERE ((`ArticleID` = ?) AND ((? = 1 AND `Rating` IS NULL) OR (`Rating` = ?)) AND (`UserID` = ?) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Rating" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Rating" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Rating" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ArticleID" DataSetColumn="ArticleID" />
              <Mapping SourceColumn="Rating" DataSetColumn="Rating" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ArticleTagTableAdapter" GeneratorDataComponentClassName="ArticleTagTableAdapter" Name="ArticleTag" UserDataComponentName="ArticleTagTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="ArticleTag" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ArticleTag` WHERE ((`ArticleID` = ?) AND (`TagID` = ?) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_TagID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TagID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ArticleTag` (`ArticleID`, `TagID`, `UserID`, `IsActive`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="TagID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TagID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ArticleID, TagID, UserID, IsActive FROM ArticleTag</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ArticleTag` SET `ArticleID` = ?, `TagID` = ?, `UserID` = ?, `IsActive` = ? WHERE ((`ArticleID` = ?) AND (`TagID` = ?) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="TagID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TagID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_TagID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TagID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ArticleID" DataSetColumn="ArticleID" />
              <Mapping SourceColumn="TagID" DataSetColumn="TagID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ArticleTypeTableAdapter" GeneratorDataComponentClassName="ArticleTypeTableAdapter" Name="ArticleType" UserDataComponentName="ArticleTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="ArticleType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ArticleType` WHERE ((`ArticleTypeID` = ?) AND ((? = 1 AND `ArticleTypeName` IS NULL) OR (`ArticleTypeName` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleTypeName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleTypeName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ArticleTypeName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleTypeName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ArticleType` (`ArticleTypeName`, `IsActive`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ArticleTypeName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleTypeName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ArticleTypeID, ArticleTypeName, IsActive FROM ArticleType</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ArticleType` SET `ArticleTypeName` = ?, `IsActive` = ? WHERE ((`ArticleTypeID` = ?) AND ((? = 1 AND `ArticleTypeName` IS NULL) OR (`ArticleTypeName` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ArticleTypeName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleTypeName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleTypeName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleTypeName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ArticleTypeName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleTypeName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ArticleTypeID" DataSetColumn="ArticleTypeID" />
              <Mapping SourceColumn="ArticleTypeName" DataSetColumn="ArticleTypeName" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BookmarkArticleTableAdapter" GeneratorDataComponentClassName="BookmarkArticleTableAdapter" Name="BookmarkArticle" UserDataComponentName="BookmarkArticleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="BookmarkArticle" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `BookmarkArticle` WHERE ((`UserID` = ?) AND (`ArticleID` = ?) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `BookmarkArticle` (`UserID`, `ArticleID`, `IsActive`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT UserID, ArticleID, IsActive FROM BookmarkArticle</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `BookmarkArticle` SET `UserID` = ?, `ArticleID` = ?, `IsActive` = ? WHERE ((`UserID` = ?) AND (`ArticleID` = ?) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="ArticleID" DataSetColumn="ArticleID" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CommentTableAdapter" GeneratorDataComponentClassName="CommentTableAdapter" Name="Comment" UserDataComponentName="CommentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="Comment" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Comment` WHERE ((`CommentID` = ?) AND ((? = 1 AND `Comment` IS NULL) OR (`Comment` = ?)) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `ArticleID` IS NULL) OR (`ArticleID` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CommentID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CommentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Comment" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Comment" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Comment` (`Comment`, `UserID`, `ArticleID`, `IsActive`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Comment" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CommentID, Comment, UserID, ArticleID, IsActive FROM Comment</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Comment` SET `Comment` = ?, `UserID` = ?, `ArticleID` = ?, `IsActive` = ? WHERE ((`CommentID` = ?) AND ((? = 1 AND `Comment` IS NULL) OR (`Comment` = ?)) AND ((? = 1 AND `UserID` IS NULL) OR (`UserID` = ?)) AND ((? = 1 AND `ArticleID` IS NULL) OR (`ArticleID` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Comment" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CommentID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CommentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Comment" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Comment" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CommentID" DataSetColumn="CommentID" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="ArticleID" DataSetColumn="ArticleID" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StepTableAdapter" GeneratorDataComponentClassName="StepTableAdapter" Name="Step" UserDataComponentName="StepTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="Step" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Step` WHERE ((`StepID` = ?) AND ((? = 1 AND `StepName` IS NULL) OR (`StepName` = ?)) AND ((? = 1 AND `StepURL` IS NULL) OR (`StepURL` = ?)) AND ((? = 1 AND `ArticleID` IS NULL) OR (`ArticleID` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_StepID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StepID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_StepName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StepName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_StepName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StepName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_StepURL" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StepURL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_StepURL" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StepURL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Step` (`StepName`, `StepURL`, `ArticleID`, `IsActive`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="StepName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StepName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="StepURL" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StepURL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT StepID, StepName, StepURL, ArticleID, IsActive FROM Step</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Step` SET `StepName` = ?, `StepURL` = ?, `ArticleID` = ?, `IsActive` = ? WHERE ((`StepID` = ?) AND ((? = 1 AND `StepName` IS NULL) OR (`StepName` = ?)) AND ((? = 1 AND `StepURL` IS NULL) OR (`StepURL` = ?)) AND ((? = 1 AND `ArticleID` IS NULL) OR (`ArticleID` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="StepName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StepName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="StepURL" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StepURL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_StepID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StepID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_StepName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StepName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_StepName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StepName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_StepURL" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StepURL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_StepURL" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StepURL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="StepID" DataSetColumn="StepID" />
              <Mapping SourceColumn="StepName" DataSetColumn="StepName" />
              <Mapping SourceColumn="StepURL" DataSetColumn="StepURL" />
              <Mapping SourceColumn="ArticleID" DataSetColumn="ArticleID" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TagTableAdapter" GeneratorDataComponentClassName="TagTableAdapter" Name="Tag" UserDataComponentName="TagTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="Tag" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Tag` WHERE ((`TagID` = ?) AND ((? = 1 AND `Tag` IS NULL) OR (`Tag` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_TagID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TagID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Tag" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Tag" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Tag" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Tag" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Tag` (`Tag`, `IsActive`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Tag" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Tag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT TagID, Tag, IsActive FROM Tag</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Tag` SET `Tag` = ?, `IsActive` = ? WHERE ((`TagID` = ?) AND ((? = 1 AND `Tag` IS NULL) OR (`Tag` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Tag" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Tag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_TagID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TagID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Tag" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Tag" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Tag" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Tag" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TagID" DataSetColumn="TagID" />
              <Mapping SourceColumn="Tag" DataSetColumn="Tag" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VehicleModelTableAdapter" GeneratorDataComponentClassName="VehicleModelTableAdapter" Name="VehicleModel" UserDataComponentName="VehicleModelTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="VehicleModel" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `VehicleModel` WHERE ((`VehicleModelID` = ?) AND ((? = 1 AND `VehicleModelName` IS NULL) OR (`VehicleModelName` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_VehicleModelName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="VehicleModelName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `VehicleModel` (`VehicleModelName`, `IsActive`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="VehicleModelName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="VehicleModelName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT VehicleModelID, VehicleModelName, IsActive FROM VehicleModel</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `VehicleModel` SET `VehicleModelName` = ?, `IsActive` = ? WHERE ((`VehicleModelID` = ?) AND ((? = 1 AND `VehicleModelName` IS NULL) OR (`VehicleModelName` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="VehicleModelName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="VehicleModelName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_VehicleModelName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="VehicleModelName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="VehicleModelID" DataSetColumn="VehicleModelID" />
              <Mapping SourceColumn="VehicleModelName" DataSetColumn="VehicleModelName" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VehicleModelTypeTableAdapter" GeneratorDataComponentClassName="VehicleModelTypeTableAdapter" Name="VehicleModelType" UserDataComponentName="VehicleModelTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="VehicleModelType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `VehicleModelType` WHERE ((`VehicleModelTypeID` = ?) AND ((? = 1 AND `VehicleModelTypeName` IS NULL) OR (`VehicleModelTypeName` = ?)) AND ((? = 1 AND `VehicleModelID` IS NULL) OR (`VehicleModelID` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelTypeName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_VehicleModelTypeName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="VehicleModelTypeName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `VehicleModelType` (`VehicleModelTypeName`, `VehicleModelID`, `IsActive`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="VehicleModelTypeName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="VehicleModelTypeName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT VehicleModelTypeID, VehicleModelTypeName, VehicleModelID, IsActive FROM VehicleModelType</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `VehicleModelType` SET `VehicleModelTypeName` = ?, `VehicleModelID` = ?, `IsActive` = ? WHERE ((`VehicleModelTypeID` = ?) AND ((? = 1 AND `VehicleModelTypeName` IS NULL) OR (`VehicleModelTypeName` = ?)) AND ((? = 1 AND `VehicleModelID` IS NULL) OR (`VehicleModelID` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="VehicleModelTypeName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="VehicleModelTypeName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelTypeName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_VehicleModelTypeName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="VehicleModelTypeName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="VehicleModelTypeID" DataSetColumn="VehicleModelTypeID" />
              <Mapping SourceColumn="VehicleModelTypeName" DataSetColumn="VehicleModelTypeName" />
              <Mapping SourceColumn="VehicleModelID" DataSetColumn="VehicleModelID" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VehicleModelTypeYearTableAdapter" GeneratorDataComponentClassName="VehicleModelTypeYearTableAdapter" Name="VehicleModelTypeYear" UserDataComponentName="VehicleModelTypeYearTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="VehicleModelTypeYear" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `VehicleModelTypeYear` WHERE ((`VehicleModelTypeYearID` = ?) AND ((? = 1 AND `VehicleModelTypeID` IS NULL) OR (`VehicleModelTypeID` = ?)) AND ((? = 1 AND `VehicleYear` IS NULL) OR (`VehicleYear` = ?)) AND ((? = 1 AND `VehicleModelTypeImageURL` IS NULL) OR (`VehicleModelTypeImageURL` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelTypeYearID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeYearID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleYear" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleYear" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleYear" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleYear" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelTypeImageURL" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeImageURL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_VehicleModelTypeImageURL" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="VehicleModelTypeImageURL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `VehicleModelTypeYear` (`VehicleModelTypeID`, `VehicleYear`, `VehicleModelTypeImageURL`, `IsActive`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="VehicleYear" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleYear" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="VehicleModelTypeImageURL" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="VehicleModelTypeImageURL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT VehicleModelTypeYearID, VehicleModelTypeID, VehicleYear, VehicleModelTypeImageURL, IsActive FROM VehicleModelTypeYear</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `VehicleModelTypeYear` SET `VehicleModelTypeID` = ?, `VehicleYear` = ?, `VehicleModelTypeImageURL` = ?, `IsActive` = ? WHERE ((`VehicleModelTypeYearID` = ?) AND ((? = 1 AND `VehicleModelTypeID` IS NULL) OR (`VehicleModelTypeID` = ?)) AND ((? = 1 AND `VehicleYear` IS NULL) OR (`VehicleYear` = ?)) AND ((? = 1 AND `VehicleModelTypeImageURL` IS NULL) OR (`VehicleModelTypeImageURL` = ?)) AND ((? = 1 AND `IsActive` IS NULL) OR (`IsActive` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="VehicleYear" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleYear" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="VehicleModelTypeImageURL" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="VehicleModelTypeImageURL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelTypeYearID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeYearID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleYear" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleYear" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VehicleYear" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleYear" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VehicleModelTypeImageURL" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeImageURL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_VehicleModelTypeImageURL" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="VehicleModelTypeImageURL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsActive" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsActive" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="VehicleModelTypeYearID" DataSetColumn="VehicleModelTypeYearID" />
              <Mapping SourceColumn="VehicleModelTypeID" DataSetColumn="VehicleModelTypeID" />
              <Mapping SourceColumn="VehicleYear" DataSetColumn="VehicleYear" />
              <Mapping SourceColumn="VehicleModelTypeImageURL" DataSetColumn="VehicleModelTypeImageURL" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ArticleUserVehicleDetailsTableAdapter" GeneratorDataComponentClassName="ArticleUserVehicleDetailsTableAdapter" Name="ArticleUserVehicleDetails" UserDataComponentName="ArticleUserVehicleDetailsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Article.ArticleID, ApplicationUser.UserName, Article.ArticleName, Article.ArticleImageUrl
FROM            ((((ApplicationUser INNER JOIN
                         Article ON ApplicationUser.UserID = Article.UserID) INNER JOIN
                         VehicleModel ON Article.VehicleModelID = VehicleModel.VehicleModelID) INNER JOIN
                         VehicleModelType ON Article.VehicleModelTypeID = VehicleModelType.VehicleModelTypeID) INNER JOIN
                         VehicleModelTypeYear ON VehicleModelType.VehicleModelTypeID = VehicleModelTypeYear.VehicleModelTypeID)
WHERE        (Article.ArticleName LIKE ?) AND (VehicleModel.VehicleModelID = ?) AND (VehicleModelType.VehicleModelTypeID = ?) AND 
                         (VehicleModelTypeYear.VehicleModelTypeYearID = ?) AND (ApplicationUser.IsActive = True) AND (Article.IsActive = True) AND (Article.IsPublished = True)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ArticleName" DataSourceName="Article" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="ArticleName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="ArticleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="VehicleModelID" DataSourceName="VehicleModel" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param3" ColumnName="VehicleModelTypeID" DataSourceName="VehicleModelType" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param4" ColumnName="VehicleModelTypeYearID" DataSourceName="VehicleModelTypeYear" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="VehicleModelTypeYearID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeYearID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ArticleID" DataSetColumn="ArticleID" />
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="ArticleName" DataSetColumn="ArticleName" />
              <Mapping SourceColumn="ArticleImageUrl" DataSetColumn="ArticleImageUrl" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ArticleArticleTypeUserID" GeneratorDataComponentClassName="ArticleArticleTypeUserID" Name="ArticleArticleTypeUserID" UserDataComponentName="ArticleArticleTypeUserID">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Article.ArticleID, Article.ArticleName, ArticleType.ArticleTypeName, Article.ArticleImageUrl
FROM            ((ApplicationUser INNER JOIN
                         Article ON ApplicationUser.UserID = Article.UserID) INNER JOIN
                         ArticleType ON Article.ArticleTypeID = ArticleType.ArticleTypeID)
WHERE        (Article.IsActive = True) AND (ApplicationUser.IsActive = True) AND (ApplicationUser.UserID = ?) AND (Article.IsPublished = False)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="UserID" DataSourceName="ApplicationUser" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ArticleID" DataSetColumn="ArticleID" />
              <Mapping SourceColumn="ArticleName" DataSetColumn="ArticleName" />
              <Mapping SourceColumn="ArticleTypeName" DataSetColumn="ArticleTypeName" />
              <Mapping SourceColumn="ArticleImageUrl" DataSetColumn="ArticleImageUrl" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ArticleCommentsArticleID" GeneratorDataComponentClassName="ArticleCommentsArticleID" Name="GetCommentArticleID" UserDataComponentName="ArticleCommentsArticleID">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Comment.Comment, ApplicationUser.UserName, ApplicationUser.ProfilePictureURL, Comment.CommentID
FROM            (ApplicationUser INNER JOIN
                         (Article INNER JOIN
                         Comment ON Article.ArticleID = Comment.ArticleID) ON ApplicationUser.UserID = Comment.UserID)
WHERE        (Comment.IsActive = True) AND (ApplicationUser.IsActive = True) AND (Article.ArticleID = ?) AND (Article.IsActive = True)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ArticleID" DataSourceName="Article" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="ProfilePictureURL" DataSetColumn="ProfilePictureURL" />
              <Mapping SourceColumn="CommentID" DataSetColumn="CommentID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GetRatingArticleID" GeneratorDataComponentClassName="GetRatingArticleID" Name="GetRatingArticleID" UserDataComponentName="GetRatingArticleID">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ROUND(AVG(ArticleRating.Rating)) AS ArticleRating
FROM            (Article INNER JOIN
                         ArticleRating ON Article.ArticleID = ArticleRating.ArticleID)
WHERE        (Article.IsActive = True) AND (ArticleRating.IsActive = True) AND (Article.ArticleID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ArticleID" DataSourceName="Article" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ArticleRating" DataSetColumn="ArticleRating" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ArticleStepArticleID" GeneratorDataComponentClassName="ArticleStepArticleID" Name="ArticleStepArticleID" UserDataComponentName="ArticleStepArticleID">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="Step" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Step.StepURL, Step.StepName
FROM            (Article INNER JOIN
                         Step ON Article.ArticleID = Step.ArticleID)
WHERE        (Article.ArticleID = ?) AND (Article.IsActive = True) AND (Step.IsActive = True)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ArticleID" DataSourceName="Article" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="StepURL" DataSetColumn="StepURL" />
              <Mapping SourceColumn="StepName" DataSetColumn="StepName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ArticleTagArticleID" GeneratorDataComponentClassName="ArticleTagArticleID" Name="GetTagArticleID" UserDataComponentName="ArticleTagArticleID">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="Tag" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Tag.Tag
FROM            ((Article INNER JOIN
                         ArticleTag ON Article.ArticleID = ArticleTag.ArticleID) INNER JOIN
                         Tag ON ArticleTag.TagID = Tag.TagID)
WHERE        (Article.ArticleID = ?) AND (Tag.IsActive = True) AND (Article.IsActive = True)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ArticleID" DataSourceName="Article" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Tag" DataSetColumn="Tag" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VehicleModelsTable" GeneratorDataComponentClassName="VehicleModelsTable" Name="VehicleModels" UserDataComponentName="VehicleModelsTable">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        VehicleModel.VehicleModelName, VehicleModelType.VehicleModelTypeName, VehicleModelTypeYear.VehicleYear, 
                         VehicleModelTypeYear.VehicleModelTypeImageURL, VehicleModel.VehicleModelID
FROM            ((VehicleModel INNER JOIN
                         VehicleModelType ON VehicleModel.VehicleModelID = VehicleModelType.VehicleModelID) INNER JOIN
                         VehicleModelTypeYear ON VehicleModelType.VehicleModelTypeID = VehicleModelTypeYear.VehicleModelTypeID)
WHERE        (VehicleModel.IsActive = True) AND (VehicleModelTypeYear.IsActive = True) AND (VehicleModelType.IsActive = True)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="VehicleModelName" DataSetColumn="VehicleModelName" />
              <Mapping SourceColumn="VehicleModelTypeName" DataSetColumn="VehicleModelTypeName" />
              <Mapping SourceColumn="VehicleYear" DataSetColumn="VehicleYear" />
              <Mapping SourceColumn="VehicleModelTypeImageURL" DataSetColumn="VehicleModelTypeImageURL" />
              <Mapping SourceColumn="VehicleModelID" DataSetColumn="VehicleModelID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VehicleModelsVehicleModelID" GeneratorDataComponentClassName="VehicleModelsVehicleModelID" Name="VehicleModelsVehicleModelID" UserDataComponentName="VehicleModelsVehicleModelID">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        VehicleModel.VehicleModelName, VehicleModelType.VehicleModelTypeName, VehicleModelTypeYear.VehicleYear, 
                         VehicleModelTypeYear.VehicleModelTypeImageURL, VehicleModelType.VehicleModelTypeID, VehicleModelTypeYear.VehicleModelTypeYearID, 
                         VehicleModel.VehicleModelID, VehicleModelType.IsActive
FROM            ((VehicleModelType INNER JOIN
                         VehicleModel ON VehicleModelType.VehicleModelID = VehicleModel.VehicleModelID) INNER JOIN
                         VehicleModelTypeYear ON VehicleModelType.VehicleModelTypeID = VehicleModelTypeYear.VehicleModelTypeID)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="VehicleModelName" DataSetColumn="VehicleModelName" />
              <Mapping SourceColumn="VehicleModelTypeName" DataSetColumn="VehicleModelTypeName" />
              <Mapping SourceColumn="VehicleYear" DataSetColumn="VehicleYear" />
              <Mapping SourceColumn="VehicleModelTypeImageURL" DataSetColumn="VehicleModelTypeImageURL" />
              <Mapping SourceColumn="VehicleModelTypeID" DataSetColumn="VehicleModelTypeID" />
              <Mapping SourceColumn="VehicleModelTypeYearID" DataSetColumn="VehicleModelTypeYearID" />
              <Mapping SourceColumn="VehicleModelID" DataSetColumn="VehicleModelID" />
              <Mapping SourceColumn="IsActive" DataSetColumn="IsActive" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ModelTypeImageTableAdapter" GeneratorDataComponentClassName="ModelTypeImageTableAdapter" Name="ModelTypeImage" UserDataComponentName="ModelTypeImageTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="VehicleModelTypeYear" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        VehicleModelTypeYear.VehicleModelTypeImageURL
FROM            ((VehicleModel INNER JOIN
                         VehicleModelType ON VehicleModel.VehicleModelID = VehicleModelType.VehicleModelID) INNER JOIN
                         VehicleModelTypeYear ON VehicleModelType.VehicleModelTypeID = VehicleModelTypeYear.VehicleModelTypeID)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="VehicleModelTypeImageURL" DataSetColumn="VehicleModelTypeImageURL" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GetUserArticlesTableAdapter" GeneratorDataComponentClassName="GetUserArticlesTableAdapter" Name="GetUserArticles" UserDataComponentName="GetUserArticlesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Article.ArticleName, Article.ArticleImageUrl, ArticleType.ArticleTypeID, Article.ArticleID, Step.StepURL, Article.IsPublished
FROM            (((ApplicationUser INNER JOIN
                         Article ON ApplicationUser.UserID = Article.UserID) INNER JOIN
                         ArticleType ON Article.ArticleTypeID = ArticleType.ArticleTypeID) INNER JOIN
                         Step ON Article.ArticleID = Step.ArticleID)
WHERE        (ApplicationUser.UserID = ?) AND (Article.IsActive = true) AND (ArticleType.IsActive = true) AND (ApplicationUser.IsActive = true)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="UserID" DataSourceName="ApplicationUser" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ArticleName" DataSetColumn="ArticleName" />
              <Mapping SourceColumn="ArticleImageUrl" DataSetColumn="ArticleImageUrl" />
              <Mapping SourceColumn="ArticleTypeID" DataSetColumn="ArticleTypeID" />
              <Mapping SourceColumn="ArticleID" DataSetColumn="ArticleID" />
              <Mapping SourceColumn="StepURL" DataSetColumn="StepURL" />
              <Mapping SourceColumn="IsPublished" DataSetColumn="IsPublished" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GetStepsUsersOrArticlesTableAdapter" GeneratorDataComponentClassName="GetStepsUsersOrArticlesTableAdapter" Name="GetStepsUsersOrArticles" UserDataComponentName="GetStepsUsersOrArticlesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Step.StepName, Step.StepID, Step.StepURL, Article.IsPublished
FROM            ((ApplicationUser INNER JOIN
                         Article ON ApplicationUser.UserID = Article.UserID) INNER JOIN
                         Step ON Article.ArticleID = Step.ArticleID)
WHERE        (Article.UserID = ?) AND (Article.ArticleID = ?) AND (ApplicationUser.IsActive = true) AND (Step.IsActive = true) AND (Article.IsActive = true)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="UserID" DataSourceName="Article" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="ArticleID" DataSourceName="Article" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="StepName" DataSetColumn="StepName" />
              <Mapping SourceColumn="StepID" DataSetColumn="StepID" />
              <Mapping SourceColumn="StepURL" DataSetColumn="StepURL" />
              <Mapping SourceColumn="IsPublished" DataSetColumn="IsPublished" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GetArticleByVehicleDetailsTableAdapter" GeneratorDataComponentClassName="GetArticleByVehicleDetailsTableAdapter" Name="GetArticleByVehicleDetails" UserDataComponentName="GetArticleByVehicleDetailsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="Article" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Article` WHERE ((`ArticleID` = ?) AND ((? = 1 AND `ArticleName` IS NULL) OR (`ArticleName` = ?)) AND ((? = 1 AND `ArticleImageUrl` IS NULL) OR (`ArticleImageUrl` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ArticleName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleImageUrl" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleImageUrl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ArticleImageUrl" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleImageUrl" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Article.ArticleID, Article.ArticleName, Article.ArticleImageUrl
FROM            (((Article INNER JOIN
                         VehicleModel ON Article.VehicleModelID = VehicleModel.VehicleModelID) INNER JOIN
                         VehicleModelType ON Article.VehicleModelTypeID = VehicleModelType.VehicleModelTypeID) INNER JOIN
                         VehicleModelTypeYear ON VehicleModelType.VehicleModelTypeID = VehicleModelTypeYear.VehicleModelTypeID)
WHERE        (VehicleModel.VehicleModelID = ?) AND (VehicleModelType.VehicleModelTypeID = ?) AND (VehicleModelTypeYear.VehicleModelTypeYearID = ?) AND 
                         (Article.IsActive = True) AND (VehicleModel.IsActive = True) AND (VehicleModelType.IsActive = True) AND (VehicleModelTypeYear.IsActive = True) AND 
                         (Article.IsPublished = True) AND (Article.ArticleName = ? )</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="VehicleModelID" DataSourceName="VehicleModel" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="VehicleModelID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="VehicleModelTypeID" DataSourceName="VehicleModelType" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="VehicleModelTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param3" ColumnName="VehicleModelTypeYearID" DataSourceName="VehicleModelTypeYear" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="VehicleModelTypeYearID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VehicleModelTypeYearID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param4" ColumnName="ArticleName" DataSourceName="Article" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="ArticleName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="ArticleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Article` SET `ArticleName` = ?, `ArticleImageUrl` = ? WHERE ((`ArticleID` = ?) AND ((? = 1 AND `ArticleName` IS NULL) OR (`ArticleName` = ?)) AND ((? = 1 AND `ArticleImageUrl` IS NULL) OR (`ArticleImageUrl` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ArticleName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ArticleImageUrl" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleImageUrl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ArticleName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ArticleImageUrl" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleImageUrl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ArticleImageUrl" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArticleImageUrl" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ArticleID" DataSetColumn="ArticleID" />
              <Mapping SourceColumn="ArticleName" DataSetColumn="ArticleName" />
              <Mapping SourceColumn="ArticleImageUrl" DataSetColumn="ArticleImageUrl" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GetArticleTypeArticleIDTableAdapter" GeneratorDataComponentClassName="GetArticleTypeArticleIDTableAdapter" Name="GetArticleTypeArticleID" UserDataComponentName="GetArticleTypeArticleIDTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="ArticleType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ArticleType` WHERE ((`ArticleTypeID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ArticleType.ArticleTypeID
FROM            (Article INNER JOIN
                         ArticleType ON Article.ArticleTypeID = ArticleType.ArticleTypeID)
WHERE        (Article.ArticleID = ?) AND (Article.IsActive = True)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ArticleID" DataSourceName="Article" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ArticleType` WHERE ((`ArticleTypeID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ArticleTypeID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ArticleTypeID" DataSetColumn="ArticleTypeID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GetUserArticleIDTableAdapter" GeneratorDataComponentClassName="GetUserArticleIDTableAdapter" Name="GetUserArticleID" UserDataComponentName="GetUserArticleIDTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectName="ApplicationUser" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ApplicationUser.UserName, ApplicationUser.ProfilePictureURL, ApplicationUser.UserID
FROM            (ApplicationUser INNER JOIN
                         Article ON ApplicationUser.UserID = Article.UserID)
WHERE        (ApplicationUser.IsActive = true) AND (Article.IsActive = true) AND (Article.ArticleID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ArticleID" DataSourceName="Article" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="ProfilePictureURL" DataSetColumn="ProfilePictureURL" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GetVehicleDetailsArticleIDTableAdapter" GeneratorDataComponentClassName="GetVehicleDetailsArticleIDTableAdapter" Name="GetVehicleDetailsArticleID" UserDataComponentName="GetVehicleDetailsArticleIDTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AutoFix_FinalConnectionString1 (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        VehicleModel.VehicleModelName, VehicleModelType.VehicleModelTypeName, VehicleModelTypeYear.VehicleYear, 
                         VehicleModelTypeYear.VehicleModelTypeImageURL, VehicleModel.VehicleModelID, VehicleModelType.VehicleModelTypeID, 
                         VehicleModelTypeYear.VehicleModelTypeYearID
FROM            (((VehicleModel INNER JOIN
                         VehicleModelType ON VehicleModel.VehicleModelID = VehicleModelType.VehicleModelID) INNER JOIN
                         VehicleModelTypeYear ON VehicleModelType.VehicleModelTypeID = VehicleModelTypeYear.VehicleModelTypeID) INNER JOIN
                         Article ON VehicleModel.VehicleModelID = Article.VehicleModelID AND VehicleModelType.VehicleModelTypeID = Article.VehicleModelTypeID)
WHERE        (VehicleModel.IsActive = True) AND (VehicleModelType.IsActive = True) AND (VehicleModelTypeYear.IsActive = True) AND (Article.ArticleID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ArticleID" DataSourceName="Article" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ArticleID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ArticleID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="VehicleModelName" DataSetColumn="VehicleModelName" />
              <Mapping SourceColumn="VehicleModelTypeName" DataSetColumn="VehicleModelTypeName" />
              <Mapping SourceColumn="VehicleYear" DataSetColumn="VehicleYear" />
              <Mapping SourceColumn="VehicleModelTypeImageURL" DataSetColumn="VehicleModelTypeImageURL" />
              <Mapping SourceColumn="VehicleModelID" DataSetColumn="VehicleModelID" />
              <Mapping SourceColumn="VehicleModelTypeID" DataSetColumn="VehicleModelTypeID" />
              <Mapping SourceColumn="VehicleModelTypeYearID" DataSetColumn="VehicleModelTypeYearID" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="AutoFixDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="AutoFixDataSet" msprop:Generator_UserDSName="AutoFixDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ApplicationUser" msprop:Generator_TableClassName="ApplicationUserDataTable" msprop:Generator_TableVarName="tableApplicationUser" msprop:Generator_RowChangedName="ApplicationUserRowChanged" msprop:Generator_TablePropName="ApplicationUser" msprop:Generator_RowDeletingName="ApplicationUserRowDeleting" msprop:Generator_RowChangingName="ApplicationUserRowChanging" msprop:Generator_RowEvHandlerName="ApplicationUserRowChangeEventHandler" msprop:Generator_RowDeletedName="ApplicationUserRowDeleted" msprop:Generator_RowClassName="ApplicationUserRow" msprop:Generator_UserTableName="ApplicationUser" msprop:Generator_RowEvArgName="ApplicationUserRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" />
              <xs:element name="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" msprop:Generator_UserColumnName="FirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" msprop:Generator_UserColumnName="LastName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmailAddress" msprop:Generator_ColumnVarNameInTable="columnEmailAddress" msprop:Generator_ColumnPropNameInRow="EmailAddress" msprop:Generator_ColumnPropNameInTable="EmailAddressColumn" msprop:Generator_UserColumnName="EmailAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProfilePictureURL" msprop:Generator_ColumnVarNameInTable="columnProfilePictureURL" msprop:Generator_ColumnPropNameInRow="ProfilePictureURL" msprop:Generator_ColumnPropNameInTable="ProfilePictureURLColumn" msprop:Generator_UserColumnName="ProfilePictureURL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_UserColumnName="City" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnPropNameInTable="CountryColumn" msprop:Generator_UserColumnName="Country" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PhoneNumber" msprop:Generator_ColumnVarNameInTable="columnPhoneNumber" msprop:Generator_ColumnPropNameInRow="PhoneNumber" msprop:Generator_ColumnPropNameInTable="PhoneNumberColumn" msprop:Generator_UserColumnName="PhoneNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserTypeID" msprop:Generator_ColumnVarNameInTable="columnUserTypeID" msprop:Generator_ColumnPropNameInRow="UserTypeID" msprop:Generator_ColumnPropNameInTable="UserTypeIDColumn" msprop:Generator_UserColumnName="UserTypeID" type="xs:int" minOccurs="0" />
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ApplicationUserType" msprop:Generator_TableClassName="ApplicationUserTypeDataTable" msprop:Generator_TableVarName="tableApplicationUserType" msprop:Generator_RowChangedName="ApplicationUserTypeRowChanged" msprop:Generator_TablePropName="ApplicationUserType" msprop:Generator_RowDeletingName="ApplicationUserTypeRowDeleting" msprop:Generator_RowChangingName="ApplicationUserTypeRowChanging" msprop:Generator_RowEvHandlerName="ApplicationUserTypeRowChangeEventHandler" msprop:Generator_RowDeletedName="ApplicationUserTypeRowDeleted" msprop:Generator_RowClassName="ApplicationUserTypeRow" msprop:Generator_UserTableName="ApplicationUserType" msprop:Generator_RowEvArgName="ApplicationUserTypeRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserTypeID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnUserTypeID" msprop:Generator_ColumnPropNameInRow="UserTypeID" msprop:Generator_ColumnPropNameInTable="UserTypeIDColumn" msprop:Generator_UserColumnName="UserTypeID" type="xs:int" />
              <xs:element name="UserType" msprop:Generator_ColumnVarNameInTable="columnUserType" msprop:Generator_ColumnPropNameInRow="UserType" msprop:Generator_ColumnPropNameInTable="UserTypeColumn" msprop:Generator_UserColumnName="UserType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Article" msprop:Generator_TableClassName="ArticleDataTable" msprop:Generator_TableVarName="tableArticle" msprop:Generator_RowChangedName="ArticleRowChanged" msprop:Generator_TablePropName="Article" msprop:Generator_RowDeletingName="ArticleRowDeleting" msprop:Generator_RowChangingName="ArticleRowChanging" msprop:Generator_RowEvHandlerName="ArticleRowChangeEventHandler" msprop:Generator_RowDeletedName="ArticleRowDeleted" msprop:Generator_RowClassName="ArticleRow" msprop:Generator_UserTableName="Article" msprop:Generator_RowEvArgName="ArticleRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ArticleID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnArticleID" msprop:Generator_ColumnPropNameInRow="ArticleID" msprop:Generator_ColumnPropNameInTable="ArticleIDColumn" msprop:Generator_UserColumnName="ArticleID" type="xs:int" />
              <xs:element name="ArticleName" msprop:Generator_ColumnVarNameInTable="columnArticleName" msprop:Generator_ColumnPropNameInRow="ArticleName" msprop:Generator_ColumnPropNameInTable="ArticleNameColumn" msprop:Generator_UserColumnName="ArticleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArticleImageUrl" msprop:Generator_ColumnVarNameInTable="columnArticleImageUrl" msprop:Generator_ColumnPropNameInRow="ArticleImageUrl" msprop:Generator_ColumnPropNameInTable="ArticleImageUrlColumn" msprop:Generator_UserColumnName="ArticleImageUrl" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArticleTypeID" msprop:Generator_ColumnVarNameInTable="columnArticleTypeID" msprop:Generator_ColumnPropNameInRow="ArticleTypeID" msprop:Generator_ColumnPropNameInTable="ArticleTypeIDColumn" msprop:Generator_UserColumnName="ArticleTypeID" type="xs:int" minOccurs="0" />
              <xs:element name="VehicleModelID" msprop:Generator_ColumnVarNameInTable="columnVehicleModelID" msprop:Generator_ColumnPropNameInRow="VehicleModelID" msprop:Generator_ColumnPropNameInTable="VehicleModelIDColumn" msprop:Generator_UserColumnName="VehicleModelID" type="xs:int" minOccurs="0" />
              <xs:element name="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" minOccurs="0" />
              <xs:element name="VehicleModelTypeID" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeID" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeID" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeIDColumn" msprop:Generator_UserColumnName="VehicleModelTypeID" type="xs:int" minOccurs="0" />
              <xs:element name="VehicleModelTypeYearID" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeYearID" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeYearID" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeYearIDColumn" msprop:Generator_UserColumnName="VehicleModelTypeYearID" type="xs:int" minOccurs="0" />
              <xs:element name="LastUpdatedDate" msprop:Generator_ColumnVarNameInTable="columnLastUpdatedDate" msprop:Generator_ColumnPropNameInRow="LastUpdatedDate" msprop:Generator_ColumnPropNameInTable="LastUpdatedDateColumn" msprop:Generator_UserColumnName="LastUpdatedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IsPublished" msprop:Generator_ColumnVarNameInTable="columnIsPublished" msprop:Generator_ColumnPropNameInRow="IsPublished" msprop:Generator_ColumnPropNameInTable="IsPublishedColumn" msprop:Generator_UserColumnName="IsPublished" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ArticleRating" msprop:Generator_TableClassName="ArticleRatingDataTable" msprop:Generator_TableVarName="tableArticleRating" msprop:Generator_RowChangedName="ArticleRatingRowChanged" msprop:Generator_TablePropName="ArticleRating" msprop:Generator_RowDeletingName="ArticleRatingRowDeleting" msprop:Generator_RowChangingName="ArticleRatingRowChanging" msprop:Generator_RowEvHandlerName="ArticleRatingRowChangeEventHandler" msprop:Generator_RowDeletedName="ArticleRatingRowDeleted" msprop:Generator_RowClassName="ArticleRatingRow" msprop:Generator_UserTableName="ArticleRating" msprop:Generator_RowEvArgName="ArticleRatingRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ArticleID" msprop:Generator_ColumnVarNameInTable="columnArticleID" msprop:Generator_ColumnPropNameInRow="ArticleID" msprop:Generator_ColumnPropNameInTable="ArticleIDColumn" msprop:Generator_UserColumnName="ArticleID" type="xs:int" />
              <xs:element name="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnPropNameInTable="RatingColumn" msprop:Generator_UserColumnName="Rating" type="xs:int" minOccurs="0" />
              <xs:element name="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" />
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ArticleTag" msprop:Generator_TableClassName="ArticleTagDataTable" msprop:Generator_TableVarName="tableArticleTag" msprop:Generator_RowChangedName="ArticleTagRowChanged" msprop:Generator_TablePropName="ArticleTag" msprop:Generator_RowDeletingName="ArticleTagRowDeleting" msprop:Generator_RowChangingName="ArticleTagRowChanging" msprop:Generator_RowEvHandlerName="ArticleTagRowChangeEventHandler" msprop:Generator_RowDeletedName="ArticleTagRowDeleted" msprop:Generator_RowClassName="ArticleTagRow" msprop:Generator_UserTableName="ArticleTag" msprop:Generator_RowEvArgName="ArticleTagRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ArticleID" msprop:Generator_ColumnVarNameInTable="columnArticleID" msprop:Generator_ColumnPropNameInRow="ArticleID" msprop:Generator_ColumnPropNameInTable="ArticleIDColumn" msprop:Generator_UserColumnName="ArticleID" type="xs:int" />
              <xs:element name="TagID" msprop:Generator_ColumnVarNameInTable="columnTagID" msprop:Generator_ColumnPropNameInRow="TagID" msprop:Generator_ColumnPropNameInTable="TagIDColumn" msprop:Generator_UserColumnName="TagID" type="xs:int" />
              <xs:element name="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" minOccurs="0" />
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ArticleType" msprop:Generator_TableClassName="ArticleTypeDataTable" msprop:Generator_TableVarName="tableArticleType" msprop:Generator_RowChangedName="ArticleTypeRowChanged" msprop:Generator_TablePropName="ArticleType" msprop:Generator_RowDeletingName="ArticleTypeRowDeleting" msprop:Generator_RowChangingName="ArticleTypeRowChanging" msprop:Generator_RowEvHandlerName="ArticleTypeRowChangeEventHandler" msprop:Generator_RowDeletedName="ArticleTypeRowDeleted" msprop:Generator_RowClassName="ArticleTypeRow" msprop:Generator_UserTableName="ArticleType" msprop:Generator_RowEvArgName="ArticleTypeRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ArticleTypeID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnArticleTypeID" msprop:Generator_ColumnPropNameInRow="ArticleTypeID" msprop:Generator_ColumnPropNameInTable="ArticleTypeIDColumn" msprop:Generator_UserColumnName="ArticleTypeID" type="xs:int" />
              <xs:element name="ArticleTypeName" msprop:Generator_ColumnVarNameInTable="columnArticleTypeName" msprop:Generator_ColumnPropNameInRow="ArticleTypeName" msprop:Generator_ColumnPropNameInTable="ArticleTypeNameColumn" msprop:Generator_UserColumnName="ArticleTypeName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="BookmarkArticle" msprop:Generator_TableClassName="BookmarkArticleDataTable" msprop:Generator_TableVarName="tableBookmarkArticle" msprop:Generator_RowChangedName="BookmarkArticleRowChanged" msprop:Generator_TablePropName="BookmarkArticle" msprop:Generator_RowDeletingName="BookmarkArticleRowDeleting" msprop:Generator_RowChangingName="BookmarkArticleRowChanging" msprop:Generator_RowEvHandlerName="BookmarkArticleRowChangeEventHandler" msprop:Generator_RowDeletedName="BookmarkArticleRowDeleted" msprop:Generator_RowClassName="BookmarkArticleRow" msprop:Generator_UserTableName="BookmarkArticle" msprop:Generator_RowEvArgName="BookmarkArticleRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" />
              <xs:element name="ArticleID" msprop:Generator_ColumnVarNameInTable="columnArticleID" msprop:Generator_ColumnPropNameInRow="ArticleID" msprop:Generator_ColumnPropNameInTable="ArticleIDColumn" msprop:Generator_UserColumnName="ArticleID" type="xs:int" />
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Comment" msprop:Generator_TableClassName="CommentDataTable" msprop:Generator_TableVarName="tableComment" msprop:Generator_RowChangedName="CommentRowChanged" msprop:Generator_TablePropName="Comment" msprop:Generator_RowDeletingName="CommentRowDeleting" msprop:Generator_RowChangingName="CommentRowChanging" msprop:Generator_RowEvHandlerName="CommentRowChangeEventHandler" msprop:Generator_RowDeletedName="CommentRowDeleted" msprop:Generator_RowClassName="CommentRow" msprop:Generator_UserTableName="Comment" msprop:Generator_RowEvArgName="CommentRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CommentID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnCommentID" msprop:Generator_ColumnPropNameInRow="CommentID" msprop:Generator_ColumnPropNameInTable="CommentIDColumn" msprop:Generator_UserColumnName="CommentID" type="xs:int" />
              <xs:element name="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" msprop:Generator_UserColumnName="Comment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" minOccurs="0" />
              <xs:element name="ArticleID" msprop:Generator_ColumnVarNameInTable="columnArticleID" msprop:Generator_ColumnPropNameInRow="ArticleID" msprop:Generator_ColumnPropNameInTable="ArticleIDColumn" msprop:Generator_UserColumnName="ArticleID" type="xs:int" minOccurs="0" />
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Step" msprop:Generator_TableClassName="StepDataTable" msprop:Generator_TableVarName="tableStep" msprop:Generator_RowChangedName="StepRowChanged" msprop:Generator_TablePropName="Step" msprop:Generator_RowDeletingName="StepRowDeleting" msprop:Generator_RowChangingName="StepRowChanging" msprop:Generator_RowEvHandlerName="StepRowChangeEventHandler" msprop:Generator_RowDeletedName="StepRowDeleted" msprop:Generator_RowClassName="StepRow" msprop:Generator_UserTableName="Step" msprop:Generator_RowEvArgName="StepRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="StepID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnStepID" msprop:Generator_ColumnPropNameInRow="StepID" msprop:Generator_ColumnPropNameInTable="StepIDColumn" msprop:Generator_UserColumnName="StepID" type="xs:int" />
              <xs:element name="StepName" msprop:Generator_ColumnVarNameInTable="columnStepName" msprop:Generator_ColumnPropNameInRow="StepName" msprop:Generator_ColumnPropNameInTable="StepNameColumn" msprop:Generator_UserColumnName="StepName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StepURL" msprop:Generator_ColumnVarNameInTable="columnStepURL" msprop:Generator_ColumnPropNameInRow="StepURL" msprop:Generator_ColumnPropNameInTable="StepURLColumn" msprop:Generator_UserColumnName="StepURL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArticleID" msprop:Generator_ColumnVarNameInTable="columnArticleID" msprop:Generator_ColumnPropNameInRow="ArticleID" msprop:Generator_ColumnPropNameInTable="ArticleIDColumn" msprop:Generator_UserColumnName="ArticleID" type="xs:int" minOccurs="0" />
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tag" msprop:Generator_TableClassName="TagDataTable" msprop:Generator_TableVarName="tableTag" msprop:Generator_RowChangedName="TagRowChanged" msprop:Generator_TablePropName="Tag" msprop:Generator_RowDeletingName="TagRowDeleting" msprop:Generator_RowChangingName="TagRowChanging" msprop:Generator_RowEvHandlerName="TagRowChangeEventHandler" msprop:Generator_RowDeletedName="TagRowDeleted" msprop:Generator_RowClassName="TagRow" msprop:Generator_UserTableName="Tag" msprop:Generator_RowEvArgName="TagRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TagID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnTagID" msprop:Generator_ColumnPropNameInRow="TagID" msprop:Generator_ColumnPropNameInTable="TagIDColumn" msprop:Generator_UserColumnName="TagID" type="xs:int" />
              <xs:element name="Tag" msprop:Generator_ColumnVarNameInTable="columnTag" msprop:Generator_ColumnPropNameInRow="Tag" msprop:Generator_ColumnPropNameInTable="TagColumn" msprop:Generator_UserColumnName="Tag" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="VehicleModel" msprop:Generator_TableClassName="VehicleModelDataTable" msprop:Generator_TableVarName="tableVehicleModel" msprop:Generator_RowChangedName="VehicleModelRowChanged" msprop:Generator_TablePropName="VehicleModel" msprop:Generator_RowDeletingName="VehicleModelRowDeleting" msprop:Generator_RowChangingName="VehicleModelRowChanging" msprop:Generator_RowEvHandlerName="VehicleModelRowChangeEventHandler" msprop:Generator_RowDeletedName="VehicleModelRowDeleted" msprop:Generator_RowClassName="VehicleModelRow" msprop:Generator_UserTableName="VehicleModel" msprop:Generator_RowEvArgName="VehicleModelRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="VehicleModelID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnVehicleModelID" msprop:Generator_ColumnPropNameInRow="VehicleModelID" msprop:Generator_ColumnPropNameInTable="VehicleModelIDColumn" msprop:Generator_UserColumnName="VehicleModelID" type="xs:int" />
              <xs:element name="VehicleModelName" msprop:Generator_ColumnVarNameInTable="columnVehicleModelName" msprop:Generator_ColumnPropNameInRow="VehicleModelName" msprop:Generator_ColumnPropNameInTable="VehicleModelNameColumn" msprop:Generator_UserColumnName="VehicleModelName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="VehicleModelType" msprop:Generator_TableClassName="VehicleModelTypeDataTable" msprop:Generator_TableVarName="tableVehicleModelType" msprop:Generator_RowChangedName="VehicleModelTypeRowChanged" msprop:Generator_TablePropName="VehicleModelType" msprop:Generator_RowDeletingName="VehicleModelTypeRowDeleting" msprop:Generator_RowChangingName="VehicleModelTypeRowChanging" msprop:Generator_RowEvHandlerName="VehicleModelTypeRowChangeEventHandler" msprop:Generator_RowDeletedName="VehicleModelTypeRowDeleted" msprop:Generator_RowClassName="VehicleModelTypeRow" msprop:Generator_UserTableName="VehicleModelType" msprop:Generator_RowEvArgName="VehicleModelTypeRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="VehicleModelTypeID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeID" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeID" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeIDColumn" msprop:Generator_UserColumnName="VehicleModelTypeID" type="xs:int" />
              <xs:element name="VehicleModelTypeName" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeName" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeName" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeNameColumn" msprop:Generator_UserColumnName="VehicleModelTypeName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleModelID" msprop:Generator_ColumnVarNameInTable="columnVehicleModelID" msprop:Generator_ColumnPropNameInRow="VehicleModelID" msprop:Generator_ColumnPropNameInTable="VehicleModelIDColumn" msprop:Generator_UserColumnName="VehicleModelID" type="xs:int" minOccurs="0" />
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="VehicleModelTypeYear" msprop:Generator_TableClassName="VehicleModelTypeYearDataTable" msprop:Generator_TableVarName="tableVehicleModelTypeYear" msprop:Generator_RowChangedName="VehicleModelTypeYearRowChanged" msprop:Generator_TablePropName="VehicleModelTypeYear" msprop:Generator_RowDeletingName="VehicleModelTypeYearRowDeleting" msprop:Generator_RowChangingName="VehicleModelTypeYearRowChanging" msprop:Generator_RowEvHandlerName="VehicleModelTypeYearRowChangeEventHandler" msprop:Generator_RowDeletedName="VehicleModelTypeYearRowDeleted" msprop:Generator_RowClassName="VehicleModelTypeYearRow" msprop:Generator_UserTableName="VehicleModelTypeYear" msprop:Generator_RowEvArgName="VehicleModelTypeYearRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="VehicleModelTypeYearID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeYearID" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeYearID" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeYearIDColumn" msprop:Generator_UserColumnName="VehicleModelTypeYearID" type="xs:int" />
              <xs:element name="VehicleModelTypeID" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeID" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeID" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeIDColumn" msprop:Generator_UserColumnName="VehicleModelTypeID" type="xs:int" minOccurs="0" />
              <xs:element name="VehicleYear" msprop:Generator_ColumnVarNameInTable="columnVehicleYear" msprop:Generator_ColumnPropNameInRow="VehicleYear" msprop:Generator_ColumnPropNameInTable="VehicleYearColumn" msprop:Generator_UserColumnName="VehicleYear" type="xs:int" minOccurs="0" />
              <xs:element name="VehicleModelTypeImageURL" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeImageURL" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeImageURL" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeImageURLColumn" msprop:Generator_UserColumnName="VehicleModelTypeImageURL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ArticleUserVehicleDetails" msprop:Generator_TableClassName="ArticleUserVehicleDetailsDataTable" msprop:Generator_TableVarName="tableArticleUserVehicleDetails" msprop:Generator_TablePropName="ArticleUserVehicleDetails" msprop:Generator_RowDeletingName="ArticleUserVehicleDetailsRowDeleting" msprop:Generator_RowChangingName="ArticleUserVehicleDetailsRowChanging" msprop:Generator_RowEvHandlerName="ArticleUserVehicleDetailsRowChangeEventHandler" msprop:Generator_RowDeletedName="ArticleUserVehicleDetailsRowDeleted" msprop:Generator_UserTableName="ArticleUserVehicleDetails" msprop:Generator_RowChangedName="ArticleUserVehicleDetailsRowChanged" msprop:Generator_RowEvArgName="ArticleUserVehicleDetailsRowChangeEvent" msprop:Generator_RowClassName="ArticleUserVehicleDetailsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ArticleID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnArticleID" msprop:Generator_ColumnPropNameInRow="ArticleID" msprop:Generator_ColumnPropNameInTable="ArticleIDColumn" msprop:Generator_UserColumnName="ArticleID" type="xs:int" minOccurs="0" />
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArticleName" msprop:Generator_ColumnVarNameInTable="columnArticleName" msprop:Generator_ColumnPropNameInRow="ArticleName" msprop:Generator_ColumnPropNameInTable="ArticleNameColumn" msprop:Generator_UserColumnName="ArticleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArticleImageUrl" msprop:Generator_ColumnVarNameInTable="columnArticleImageUrl" msprop:Generator_ColumnPropNameInRow="ArticleImageUrl" msprop:Generator_ColumnPropNameInTable="ArticleImageUrlColumn" msprop:Generator_UserColumnName="ArticleImageUrl" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ArticleArticleTypeUserID" msprop:Generator_TableClassName="ArticleArticleTypeUserIDDataTable" msprop:Generator_TableVarName="tableArticleArticleTypeUserID" msprop:Generator_RowChangedName="ArticleArticleTypeUserIDRowChanged" msprop:Generator_TablePropName="ArticleArticleTypeUserID" msprop:Generator_RowDeletingName="ArticleArticleTypeUserIDRowDeleting" msprop:Generator_RowChangingName="ArticleArticleTypeUserIDRowChanging" msprop:Generator_RowEvHandlerName="ArticleArticleTypeUserIDRowChangeEventHandler" msprop:Generator_RowDeletedName="ArticleArticleTypeUserIDRowDeleted" msprop:Generator_RowClassName="ArticleArticleTypeUserIDRow" msprop:Generator_UserTableName="ArticleArticleTypeUserID" msprop:Generator_RowEvArgName="ArticleArticleTypeUserIDRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ArticleID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnArticleID" msprop:Generator_ColumnPropNameInRow="ArticleID" msprop:Generator_ColumnPropNameInTable="ArticleIDColumn" msprop:Generator_UserColumnName="ArticleID" type="xs:int" minOccurs="0" />
              <xs:element name="ArticleName" msprop:Generator_ColumnVarNameInTable="columnArticleName" msprop:Generator_ColumnPropNameInRow="ArticleName" msprop:Generator_ColumnPropNameInTable="ArticleNameColumn" msprop:Generator_UserColumnName="ArticleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArticleTypeName" msprop:Generator_ColumnVarNameInTable="columnArticleTypeName" msprop:Generator_ColumnPropNameInRow="ArticleTypeName" msprop:Generator_ColumnPropNameInTable="ArticleTypeNameColumn" msprop:Generator_UserColumnName="ArticleTypeName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArticleImageUrl" msprop:Generator_ColumnVarNameInTable="columnArticleImageUrl" msprop:Generator_ColumnPropNameInRow="ArticleImageUrl" msprop:Generator_ColumnPropNameInTable="ArticleImageUrlColumn" msprop:Generator_UserColumnName="ArticleImageUrl" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GetCommentArticleID" msprop:Generator_TableClassName="GetCommentArticleIDDataTable" msprop:Generator_TableVarName="tableGetCommentArticleID" msprop:Generator_RowChangedName="GetCommentArticleIDRowChanged" msprop:Generator_TablePropName="GetCommentArticleID" msprop:Generator_RowDeletingName="GetCommentArticleIDRowDeleting" msprop:Generator_RowChangingName="GetCommentArticleIDRowChanging" msprop:Generator_RowEvHandlerName="GetCommentArticleIDRowChangeEventHandler" msprop:Generator_RowDeletedName="GetCommentArticleIDRowDeleted" msprop:Generator_RowClassName="GetCommentArticleIDRow" msprop:Generator_UserTableName="GetCommentArticleID" msprop:Generator_RowEvArgName="GetCommentArticleIDRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" msprop:Generator_UserColumnName="Comment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProfilePictureURL" msprop:Generator_ColumnVarNameInTable="columnProfilePictureURL" msprop:Generator_ColumnPropNameInRow="ProfilePictureURL" msprop:Generator_ColumnPropNameInTable="ProfilePictureURLColumn" msprop:Generator_UserColumnName="ProfilePictureURL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CommentID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnCommentID" msprop:Generator_ColumnPropNameInRow="CommentID" msprop:Generator_ColumnPropNameInTable="CommentIDColumn" msprop:Generator_UserColumnName="CommentID" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GetRatingArticleID" msprop:Generator_TableClassName="GetRatingArticleIDDataTable" msprop:Generator_TableVarName="tableGetRatingArticleID" msprop:Generator_RowChangedName="GetRatingArticleIDRowChanged" msprop:Generator_TablePropName="GetRatingArticleID" msprop:Generator_RowDeletingName="GetRatingArticleIDRowDeleting" msprop:Generator_RowChangingName="GetRatingArticleIDRowChanging" msprop:Generator_RowEvHandlerName="GetRatingArticleIDRowChangeEventHandler" msprop:Generator_RowDeletedName="GetRatingArticleIDRowDeleted" msprop:Generator_RowClassName="GetRatingArticleIDRow" msprop:Generator_UserTableName="GetRatingArticleID" msprop:Generator_RowEvArgName="GetRatingArticleIDRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ArticleRating" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnArticleRating" msprop:Generator_ColumnPropNameInRow="ArticleRating" msprop:Generator_ColumnPropNameInTable="ArticleRatingColumn" msprop:Generator_UserColumnName="ArticleRating" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ArticleStepArticleID" msprop:Generator_TableClassName="ArticleStepArticleIDDataTable" msprop:Generator_TableVarName="tableArticleStepArticleID" msprop:Generator_RowChangedName="ArticleStepArticleIDRowChanged" msprop:Generator_TablePropName="ArticleStepArticleID" msprop:Generator_RowDeletingName="ArticleStepArticleIDRowDeleting" msprop:Generator_RowChangingName="ArticleStepArticleIDRowChanging" msprop:Generator_RowEvHandlerName="ArticleStepArticleIDRowChangeEventHandler" msprop:Generator_RowDeletedName="ArticleStepArticleIDRowDeleted" msprop:Generator_RowClassName="ArticleStepArticleIDRow" msprop:Generator_UserTableName="ArticleStepArticleID" msprop:Generator_RowEvArgName="ArticleStepArticleIDRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="StepURL" msprop:Generator_ColumnVarNameInTable="columnStepURL" msprop:Generator_ColumnPropNameInRow="StepURL" msprop:Generator_ColumnPropNameInTable="StepURLColumn" msprop:Generator_UserColumnName="StepURL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StepName" msprop:Generator_ColumnVarNameInTable="columnStepName" msprop:Generator_ColumnPropNameInRow="StepName" msprop:Generator_ColumnPropNameInTable="StepNameColumn" msprop:Generator_UserColumnName="StepName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GetTagArticleID" msprop:Generator_TableClassName="GetTagArticleIDDataTable" msprop:Generator_TableVarName="tableGetTagArticleID" msprop:Generator_RowChangedName="GetTagArticleIDRowChanged" msprop:Generator_TablePropName="GetTagArticleID" msprop:Generator_RowDeletingName="GetTagArticleIDRowDeleting" msprop:Generator_RowChangingName="GetTagArticleIDRowChanging" msprop:Generator_RowEvHandlerName="GetTagArticleIDRowChangeEventHandler" msprop:Generator_RowDeletedName="GetTagArticleIDRowDeleted" msprop:Generator_RowClassName="GetTagArticleIDRow" msprop:Generator_UserTableName="GetTagArticleID" msprop:Generator_RowEvArgName="GetTagArticleIDRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Tag" msprop:Generator_ColumnVarNameInTable="columnTag" msprop:Generator_ColumnPropNameInRow="Tag" msprop:Generator_ColumnPropNameInTable="TagColumn" msprop:Generator_UserColumnName="Tag" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="VehicleModels" msprop:Generator_TableClassName="VehicleModelsDataTable" msprop:Generator_TableVarName="tableVehicleModels" msprop:Generator_RowChangedName="VehicleModelsRowChanged" msprop:Generator_TablePropName="VehicleModels" msprop:Generator_RowDeletingName="VehicleModelsRowDeleting" msprop:Generator_RowChangingName="VehicleModelsRowChanging" msprop:Generator_RowEvHandlerName="VehicleModelsRowChangeEventHandler" msprop:Generator_RowDeletedName="VehicleModelsRowDeleted" msprop:Generator_RowClassName="VehicleModelsRow" msprop:Generator_UserTableName="VehicleModels" msprop:Generator_RowEvArgName="VehicleModelsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="VehicleModelName" msprop:Generator_ColumnVarNameInTable="columnVehicleModelName" msprop:Generator_ColumnPropNameInRow="VehicleModelName" msprop:Generator_ColumnPropNameInTable="VehicleModelNameColumn" msprop:Generator_UserColumnName="VehicleModelName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleModelTypeName" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeName" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeName" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeNameColumn" msprop:Generator_UserColumnName="VehicleModelTypeName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleYear" msprop:Generator_ColumnVarNameInTable="columnVehicleYear" msprop:Generator_ColumnPropNameInRow="VehicleYear" msprop:Generator_ColumnPropNameInTable="VehicleYearColumn" msprop:Generator_UserColumnName="VehicleYear" type="xs:int" minOccurs="0" />
              <xs:element name="VehicleModelTypeImageURL" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeImageURL" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeImageURL" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeImageURLColumn" msprop:Generator_UserColumnName="VehicleModelTypeImageURL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleModelID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnVehicleModelID" msprop:Generator_ColumnPropNameInRow="VehicleModelID" msprop:Generator_ColumnPropNameInTable="VehicleModelIDColumn" msprop:Generator_UserColumnName="VehicleModelID" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="VehicleModelsVehicleModelID" msprop:Generator_TableClassName="VehicleModelsVehicleModelIDDataTable" msprop:Generator_TableVarName="tableVehicleModelsVehicleModelID" msprop:Generator_RowChangedName="VehicleModelsVehicleModelIDRowChanged" msprop:Generator_TablePropName="VehicleModelsVehicleModelID" msprop:Generator_RowDeletingName="VehicleModelsVehicleModelIDRowDeleting" msprop:Generator_RowChangingName="VehicleModelsVehicleModelIDRowChanging" msprop:Generator_RowEvHandlerName="VehicleModelsVehicleModelIDRowChangeEventHandler" msprop:Generator_RowDeletedName="VehicleModelsVehicleModelIDRowDeleted" msprop:Generator_RowClassName="VehicleModelsVehicleModelIDRow" msprop:Generator_UserTableName="VehicleModelsVehicleModelID" msprop:Generator_RowEvArgName="VehicleModelsVehicleModelIDRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="VehicleModelName" msprop:Generator_ColumnVarNameInTable="columnVehicleModelName" msprop:Generator_ColumnPropNameInRow="VehicleModelName" msprop:Generator_ColumnPropNameInTable="VehicleModelNameColumn" msprop:Generator_UserColumnName="VehicleModelName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleModelTypeName" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeName" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeName" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeNameColumn" msprop:Generator_UserColumnName="VehicleModelTypeName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleYear" msprop:Generator_ColumnVarNameInTable="columnVehicleYear" msprop:Generator_ColumnPropNameInRow="VehicleYear" msprop:Generator_ColumnPropNameInTable="VehicleYearColumn" msprop:Generator_UserColumnName="VehicleYear" type="xs:int" minOccurs="0" />
              <xs:element name="VehicleModelTypeImageURL" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeImageURL" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeImageURL" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeImageURLColumn" msprop:Generator_UserColumnName="VehicleModelTypeImageURL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleModelTypeID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeID" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeID" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeIDColumn" msprop:Generator_UserColumnName="VehicleModelTypeID" type="xs:int" minOccurs="0" />
              <xs:element name="VehicleModelTypeYearID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeYearID" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeYearID" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeYearIDColumn" msprop:Generator_UserColumnName="VehicleModelTypeYearID" type="xs:int" minOccurs="0" />
              <xs:element name="VehicleModelID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnVehicleModelID" msprop:Generator_ColumnPropNameInRow="VehicleModelID" msprop:Generator_ColumnPropNameInTable="VehicleModelIDColumn" msprop:Generator_UserColumnName="VehicleModelID" type="xs:int" minOccurs="0" />
              <xs:element name="IsActive" msprop:Generator_ColumnVarNameInTable="columnIsActive" msprop:Generator_ColumnPropNameInRow="IsActive" msprop:Generator_ColumnPropNameInTable="IsActiveColumn" msprop:Generator_UserColumnName="IsActive" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ModelTypeImage" msprop:Generator_TableClassName="ModelTypeImageDataTable" msprop:Generator_TableVarName="tableModelTypeImage" msprop:Generator_RowChangedName="ModelTypeImageRowChanged" msprop:Generator_TablePropName="ModelTypeImage" msprop:Generator_RowDeletingName="ModelTypeImageRowDeleting" msprop:Generator_RowChangingName="ModelTypeImageRowChanging" msprop:Generator_RowEvHandlerName="ModelTypeImageRowChangeEventHandler" msprop:Generator_RowDeletedName="ModelTypeImageRowDeleted" msprop:Generator_RowClassName="ModelTypeImageRow" msprop:Generator_UserTableName="ModelTypeImage" msprop:Generator_RowEvArgName="ModelTypeImageRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="VehicleModelTypeImageURL" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeImageURL" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeImageURL" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeImageURLColumn" msprop:Generator_UserColumnName="VehicleModelTypeImageURL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GetUserArticles" msprop:Generator_TableClassName="GetUserArticlesDataTable" msprop:Generator_TableVarName="tableGetUserArticles" msprop:Generator_TablePropName="GetUserArticles" msprop:Generator_RowDeletingName="GetUserArticlesRowDeleting" msprop:Generator_RowChangingName="GetUserArticlesRowChanging" msprop:Generator_RowEvHandlerName="GetUserArticlesRowChangeEventHandler" msprop:Generator_RowDeletedName="GetUserArticlesRowDeleted" msprop:Generator_UserTableName="GetUserArticles" msprop:Generator_RowChangedName="GetUserArticlesRowChanged" msprop:Generator_RowEvArgName="GetUserArticlesRowChangeEvent" msprop:Generator_RowClassName="GetUserArticlesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ArticleName" msprop:Generator_ColumnVarNameInTable="columnArticleName" msprop:Generator_ColumnPropNameInRow="ArticleName" msprop:Generator_ColumnPropNameInTable="ArticleNameColumn" msprop:Generator_UserColumnName="ArticleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArticleImageUrl" msprop:Generator_ColumnVarNameInTable="columnArticleImageUrl" msprop:Generator_ColumnPropNameInRow="ArticleImageUrl" msprop:Generator_ColumnPropNameInTable="ArticleImageUrlColumn" msprop:Generator_UserColumnName="ArticleImageUrl" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArticleTypeID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnArticleTypeID" msprop:Generator_ColumnPropNameInRow="ArticleTypeID" msprop:Generator_ColumnPropNameInTable="ArticleTypeIDColumn" msprop:Generator_UserColumnName="ArticleTypeID" type="xs:int" minOccurs="0" />
              <xs:element name="ArticleID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnArticleID" msprop:Generator_ColumnPropNameInRow="ArticleID" msprop:Generator_ColumnPropNameInTable="ArticleIDColumn" msprop:Generator_UserColumnName="ArticleID" type="xs:int" minOccurs="0" />
              <xs:element name="StepURL" msprop:Generator_ColumnVarNameInTable="columnStepURL" msprop:Generator_ColumnPropNameInRow="StepURL" msprop:Generator_ColumnPropNameInTable="StepURLColumn" msprop:Generator_UserColumnName="StepURL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsPublished" msprop:Generator_ColumnVarNameInTable="columnIsPublished" msprop:Generator_ColumnPropNameInRow="IsPublished" msprop:Generator_ColumnPropNameInTable="IsPublishedColumn" msprop:Generator_UserColumnName="IsPublished" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GetStepsUsersOrArticles" msprop:Generator_TableClassName="GetStepsUsersOrArticlesDataTable" msprop:Generator_TableVarName="tableGetStepsUsersOrArticles" msprop:Generator_TablePropName="GetStepsUsersOrArticles" msprop:Generator_RowDeletingName="GetStepsUsersOrArticlesRowDeleting" msprop:Generator_RowChangingName="GetStepsUsersOrArticlesRowChanging" msprop:Generator_RowEvHandlerName="GetStepsUsersOrArticlesRowChangeEventHandler" msprop:Generator_RowDeletedName="GetStepsUsersOrArticlesRowDeleted" msprop:Generator_UserTableName="GetStepsUsersOrArticles" msprop:Generator_RowChangedName="GetStepsUsersOrArticlesRowChanged" msprop:Generator_RowEvArgName="GetStepsUsersOrArticlesRowChangeEvent" msprop:Generator_RowClassName="GetStepsUsersOrArticlesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="StepName" msprop:Generator_ColumnVarNameInTable="columnStepName" msprop:Generator_ColumnPropNameInRow="StepName" msprop:Generator_ColumnPropNameInTable="StepNameColumn" msprop:Generator_UserColumnName="StepName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StepID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnStepID" msprop:Generator_ColumnPropNameInRow="StepID" msprop:Generator_ColumnPropNameInTable="StepIDColumn" msprop:Generator_UserColumnName="StepID" type="xs:int" />
              <xs:element name="StepURL" msprop:Generator_ColumnVarNameInTable="columnStepURL" msprop:Generator_ColumnPropNameInRow="StepURL" msprop:Generator_ColumnPropNameInTable="StepURLColumn" msprop:Generator_UserColumnName="StepURL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsPublished" msprop:Generator_ColumnVarNameInTable="columnIsPublished" msprop:Generator_ColumnPropNameInRow="IsPublished" msprop:Generator_ColumnPropNameInTable="IsPublishedColumn" msprop:Generator_UserColumnName="IsPublished" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GetArticleByVehicleDetails" msprop:Generator_TableClassName="GetArticleByVehicleDetailsDataTable" msprop:Generator_TableVarName="tableGetArticleByVehicleDetails" msprop:Generator_RowChangedName="GetArticleByVehicleDetailsRowChanged" msprop:Generator_TablePropName="GetArticleByVehicleDetails" msprop:Generator_RowDeletingName="GetArticleByVehicleDetailsRowDeleting" msprop:Generator_RowChangingName="GetArticleByVehicleDetailsRowChanging" msprop:Generator_RowEvHandlerName="GetArticleByVehicleDetailsRowChangeEventHandler" msprop:Generator_RowDeletedName="GetArticleByVehicleDetailsRowDeleted" msprop:Generator_RowClassName="GetArticleByVehicleDetailsRow" msprop:Generator_UserTableName="GetArticleByVehicleDetails" msprop:Generator_RowEvArgName="GetArticleByVehicleDetailsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ArticleID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnArticleID" msprop:Generator_ColumnPropNameInRow="ArticleID" msprop:Generator_ColumnPropNameInTable="ArticleIDColumn" msprop:Generator_UserColumnName="ArticleID" type="xs:int" />
              <xs:element name="ArticleName" msprop:Generator_ColumnVarNameInTable="columnArticleName" msprop:Generator_ColumnPropNameInRow="ArticleName" msprop:Generator_ColumnPropNameInTable="ArticleNameColumn" msprop:Generator_UserColumnName="ArticleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArticleImageUrl" msprop:Generator_ColumnVarNameInTable="columnArticleImageUrl" msprop:Generator_ColumnPropNameInRow="ArticleImageUrl" msprop:Generator_ColumnPropNameInTable="ArticleImageUrlColumn" msprop:Generator_UserColumnName="ArticleImageUrl" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GetArticleTypeArticleID" msprop:Generator_TableClassName="GetArticleTypeArticleIDDataTable" msprop:Generator_TableVarName="tableGetArticleTypeArticleID" msprop:Generator_RowChangedName="GetArticleTypeArticleIDRowChanged" msprop:Generator_TablePropName="GetArticleTypeArticleID" msprop:Generator_RowDeletingName="GetArticleTypeArticleIDRowDeleting" msprop:Generator_RowChangingName="GetArticleTypeArticleIDRowChanging" msprop:Generator_RowEvHandlerName="GetArticleTypeArticleIDRowChangeEventHandler" msprop:Generator_RowDeletedName="GetArticleTypeArticleIDRowDeleted" msprop:Generator_RowClassName="GetArticleTypeArticleIDRow" msprop:Generator_UserTableName="GetArticleTypeArticleID" msprop:Generator_RowEvArgName="GetArticleTypeArticleIDRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ArticleTypeID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnArticleTypeID" msprop:Generator_ColumnPropNameInRow="ArticleTypeID" msprop:Generator_ColumnPropNameInTable="ArticleTypeIDColumn" msprop:Generator_UserColumnName="ArticleTypeID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GetUserArticleID" msprop:Generator_TableClassName="GetUserArticleIDDataTable" msprop:Generator_TableVarName="tableGetUserArticleID" msprop:Generator_RowChangedName="GetUserArticleIDRowChanged" msprop:Generator_TablePropName="GetUserArticleID" msprop:Generator_RowDeletingName="GetUserArticleIDRowDeleting" msprop:Generator_RowChangingName="GetUserArticleIDRowChanging" msprop:Generator_RowEvHandlerName="GetUserArticleIDRowChangeEventHandler" msprop:Generator_RowDeletedName="GetUserArticleIDRowDeleted" msprop:Generator_RowClassName="GetUserArticleIDRow" msprop:Generator_UserTableName="GetUserArticleID" msprop:Generator_RowEvArgName="GetUserArticleIDRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProfilePictureURL" msprop:Generator_ColumnVarNameInTable="columnProfilePictureURL" msprop:Generator_ColumnPropNameInRow="ProfilePictureURL" msprop:Generator_ColumnPropNameInTable="ProfilePictureURLColumn" msprop:Generator_UserColumnName="ProfilePictureURL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GetVehicleDetailsArticleID" msprop:Generator_TableClassName="GetVehicleDetailsArticleIDDataTable" msprop:Generator_TableVarName="tableGetVehicleDetailsArticleID" msprop:Generator_RowChangedName="GetVehicleDetailsArticleIDRowChanged" msprop:Generator_TablePropName="GetVehicleDetailsArticleID" msprop:Generator_RowDeletingName="GetVehicleDetailsArticleIDRowDeleting" msprop:Generator_RowChangingName="GetVehicleDetailsArticleIDRowChanging" msprop:Generator_RowEvHandlerName="GetVehicleDetailsArticleIDRowChangeEventHandler" msprop:Generator_RowDeletedName="GetVehicleDetailsArticleIDRowDeleted" msprop:Generator_RowClassName="GetVehicleDetailsArticleIDRow" msprop:Generator_UserTableName="GetVehicleDetailsArticleID" msprop:Generator_RowEvArgName="GetVehicleDetailsArticleIDRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="VehicleModelName" msprop:Generator_ColumnVarNameInTable="columnVehicleModelName" msprop:Generator_ColumnPropNameInRow="VehicleModelName" msprop:Generator_ColumnPropNameInTable="VehicleModelNameColumn" msprop:Generator_UserColumnName="VehicleModelName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleModelTypeName" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeName" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeName" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeNameColumn" msprop:Generator_UserColumnName="VehicleModelTypeName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleYear" msprop:Generator_ColumnVarNameInTable="columnVehicleYear" msprop:Generator_ColumnPropNameInRow="VehicleYear" msprop:Generator_ColumnPropNameInTable="VehicleYearColumn" msprop:Generator_UserColumnName="VehicleYear" type="xs:int" minOccurs="0" />
              <xs:element name="VehicleModelTypeImageURL" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeImageURL" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeImageURL" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeImageURLColumn" msprop:Generator_UserColumnName="VehicleModelTypeImageURL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VehicleModelID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnVehicleModelID" msprop:Generator_ColumnPropNameInRow="VehicleModelID" msprop:Generator_ColumnPropNameInTable="VehicleModelIDColumn" msprop:Generator_UserColumnName="VehicleModelID" type="xs:int" minOccurs="0" />
              <xs:element name="VehicleModelTypeID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeID" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeID" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeIDColumn" msprop:Generator_UserColumnName="VehicleModelTypeID" type="xs:int" minOccurs="0" />
              <xs:element name="VehicleModelTypeYearID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnVehicleModelTypeYearID" msprop:Generator_ColumnPropNameInRow="VehicleModelTypeYearID" msprop:Generator_ColumnPropNameInTable="VehicleModelTypeYearIDColumn" msprop:Generator_UserColumnName="VehicleModelTypeYearID" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ApplicationUser" />
      <xs:field xpath="mstns:UserID" />
    </xs:unique>
    <xs:unique name="ApplicationUserType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ApplicationUserType" />
      <xs:field xpath="mstns:UserTypeID" />
    </xs:unique>
    <xs:unique name="Article_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Article" />
      <xs:field xpath="mstns:ArticleID" />
    </xs:unique>
    <xs:unique name="ArticleRating_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ArticleRating" />
      <xs:field xpath="mstns:ArticleID" />
      <xs:field xpath="mstns:UserID" />
    </xs:unique>
    <xs:unique name="ArticleTag_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ArticleTag" />
      <xs:field xpath="mstns:ArticleID" />
      <xs:field xpath="mstns:TagID" />
    </xs:unique>
    <xs:unique name="ArticleType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ArticleType" />
      <xs:field xpath="mstns:ArticleTypeID" />
    </xs:unique>
    <xs:unique name="BookmarkArticle_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BookmarkArticle" />
      <xs:field xpath="mstns:UserID" />
      <xs:field xpath="mstns:ArticleID" />
    </xs:unique>
    <xs:unique name="Comment_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Comment" />
      <xs:field xpath="mstns:CommentID" />
    </xs:unique>
    <xs:unique name="Step_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Step" />
      <xs:field xpath="mstns:StepID" />
    </xs:unique>
    <xs:unique name="Tag_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tag" />
      <xs:field xpath="mstns:TagID" />
    </xs:unique>
    <xs:unique name="VehicleModel_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:VehicleModel" />
      <xs:field xpath="mstns:VehicleModelID" />
    </xs:unique>
    <xs:unique name="VehicleModelType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:VehicleModelType" />
      <xs:field xpath="mstns:VehicleModelTypeID" />
    </xs:unique>
    <xs:unique name="VehicleModelTypeYear_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:VehicleModelTypeYear" />
      <xs:field xpath="mstns:VehicleModelTypeYearID" />
    </xs:unique>
    <xs:unique name="GetStepsUsersOrArticles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GetStepsUsersOrArticles" />
      <xs:field xpath="mstns:StepID" />
    </xs:unique>
    <xs:unique name="GetArticleByVehicleDetails_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GetArticleByVehicleDetails" />
      <xs:field xpath="mstns:ArticleID" />
    </xs:unique>
    <xs:unique name="GetArticleTypeArticleID_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GetArticleTypeArticleID" />
      <xs:field xpath="mstns:ArticleTypeID" />
    </xs:unique>
    <xs:unique name="GetUserArticleID_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GetUserArticleID" />
      <xs:field xpath="mstns:UserID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="ApplicationUserTypeApplicationUser" msdata:parent="ApplicationUserType" msdata:child="ApplicationUser" msdata:parentkey="UserTypeID" msdata:childkey="UserTypeID" msprop:Generator_UserChildTable="ApplicationUser" msprop:Generator_ChildPropName="GetApplicationUserRows" msprop:Generator_UserRelationName="ApplicationUserTypeApplicationUser" msprop:Generator_ParentPropName="ApplicationUserTypeRow" msprop:Generator_RelationVarName="relationApplicationUserTypeApplicationUser" msprop:Generator_UserParentTable="ApplicationUserType" />
      <msdata:Relationship name="ArticleTypesArticles" msdata:parent="ArticleType" msdata:child="Article" msdata:parentkey="ArticleTypeID" msdata:childkey="ArticleTypeID" msprop:Generator_UserChildTable="Article" msprop:Generator_ChildPropName="GetArticleRows" msprop:Generator_UserRelationName="ArticleTypesArticles" msprop:Generator_ParentPropName="ArticleTypeRow" msprop:Generator_RelationVarName="relationArticleTypesArticles" msprop:Generator_UserParentTable="ArticleType" />
      <msdata:Relationship name="VehicleModelsArticles" msdata:parent="VehicleModel" msdata:child="Article" msdata:parentkey="VehicleModelID" msdata:childkey="VehicleModelID" msprop:Generator_UserChildTable="Article" msprop:Generator_ChildPropName="GetArticleRows" msprop:Generator_UserRelationName="VehicleModelsArticles" msprop:Generator_ParentPropName="VehicleModelRow" msprop:Generator_RelationVarName="relationVehicleModelsArticles" msprop:Generator_UserParentTable="VehicleModel" />
      <msdata:Relationship name="VehicleModelTypesArticles" msdata:parent="VehicleModelType" msdata:child="Article" msdata:parentkey="VehicleModelTypeID" msdata:childkey="VehicleModelTypeID" msprop:Generator_UserChildTable="Article" msprop:Generator_ChildPropName="GetArticleRows" msprop:Generator_UserRelationName="VehicleModelTypesArticles" msprop:Generator_ParentPropName="VehicleModelTypeRow" msprop:Generator_RelationVarName="relationVehicleModelTypesArticles" msprop:Generator_UserParentTable="VehicleModelType" />
      <msdata:Relationship name="ArticlesArticleRatings" msdata:parent="Article" msdata:child="ArticleRating" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="ArticleRating" msprop:Generator_ChildPropName="GetArticleRatingRows" msprop:Generator_UserRelationName="ArticlesArticleRatings" msprop:Generator_RelationVarName="relationArticlesArticleRatings" msprop:Generator_UserParentTable="Article" msprop:Generator_ParentPropName="ArticleRow" />
      <msdata:Relationship name="ArticleArticleTag" msdata:parent="Article" msdata:child="ArticleTag" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="ArticleTag" msprop:Generator_ChildPropName="GetArticleTagRows" msprop:Generator_UserRelationName="ArticleArticleTag" msprop:Generator_RelationVarName="relationArticleArticleTag" msprop:Generator_UserParentTable="Article" msprop:Generator_ParentPropName="ArticleRow" />
      <msdata:Relationship name="TagsArticleTags" msdata:parent="Tag" msdata:child="ArticleTag" msdata:parentkey="TagID" msdata:childkey="TagID" msprop:Generator_UserChildTable="ArticleTag" msprop:Generator_ChildPropName="GetArticleTagRows" msprop:Generator_UserRelationName="TagsArticleTags" msprop:Generator_ParentPropName="TagRow" msprop:Generator_RelationVarName="relationTagsArticleTags" msprop:Generator_UserParentTable="Tag" />
      <msdata:Relationship name="ArticlesBookmarkArticles" msdata:parent="Article" msdata:child="BookmarkArticle" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="BookmarkArticle" msprop:Generator_ChildPropName="GetBookmarkArticleRows" msprop:Generator_UserRelationName="ArticlesBookmarkArticles" msprop:Generator_RelationVarName="relationArticlesBookmarkArticles" msprop:Generator_UserParentTable="Article" msprop:Generator_ParentPropName="ArticleRow" />
      <msdata:Relationship name="UsersBookmarkArticles" msdata:parent="ApplicationUser" msdata:child="BookmarkArticle" msdata:parentkey="UserID" msdata:childkey="UserID" msprop:Generator_UserChildTable="BookmarkArticle" msprop:Generator_ChildPropName="GetBookmarkArticleRows" msprop:Generator_UserRelationName="UsersBookmarkArticles" msprop:Generator_RelationVarName="relationUsersBookmarkArticles" msprop:Generator_UserParentTable="ApplicationUser" msprop:Generator_ParentPropName="ApplicationUserRow" />
      <msdata:Relationship name="ArticlesComments" msdata:parent="Article" msdata:child="Comment" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="Comment" msprop:Generator_ChildPropName="GetCommentRows" msprop:Generator_UserRelationName="ArticlesComments" msprop:Generator_RelationVarName="relationArticlesComments" msprop:Generator_UserParentTable="Article" msprop:Generator_ParentPropName="ArticleRow" />
      <msdata:Relationship name="UsersComments" msdata:parent="ApplicationUser" msdata:child="Comment" msdata:parentkey="UserID" msdata:childkey="UserID" msprop:Generator_UserChildTable="Comment" msprop:Generator_ChildPropName="GetCommentRows" msprop:Generator_UserRelationName="UsersComments" msprop:Generator_RelationVarName="relationUsersComments" msprop:Generator_UserParentTable="ApplicationUser" msprop:Generator_ParentPropName="ApplicationUserRow" />
      <msdata:Relationship name="ArticlesSteps" msdata:parent="Article" msdata:child="Step" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="Step" msprop:Generator_ChildPropName="GetStepRows" msprop:Generator_UserRelationName="ArticlesSteps" msprop:Generator_RelationVarName="relationArticlesSteps" msprop:Generator_UserParentTable="Article" msprop:Generator_ParentPropName="ArticleRow" />
      <msdata:Relationship name="VehicleModelTypeVehicleModelTypeYear" msdata:parent="VehicleModelType" msdata:child="VehicleModelTypeYear" msdata:parentkey="VehicleModelTypeID" msdata:childkey="VehicleModelTypeID" msprop:Generator_UserChildTable="VehicleModelTypeYear" msprop:Generator_ChildPropName="GetVehicleModelTypeYearRows" msprop:Generator_UserRelationName="VehicleModelTypeVehicleModelTypeYear" msprop:Generator_RelationVarName="relationVehicleModelTypeVehicleModelTypeYear" msprop:Generator_UserParentTable="VehicleModelType" msprop:Generator_ParentPropName="VehicleModelTypeRow" />
      <msdata:Relationship name="ArticlesArticleRatings1" msdata:parent="ArticleArticleTypeUserID" msdata:child="ArticleRating" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="ArticleRating" msprop:Generator_ChildPropName="GetArticleRatingRows" msprop:Generator_UserRelationName="ArticlesArticleRatings1" msprop:Generator_ParentPropName="ArticleArticleTypeUserIDRow" msprop:Generator_RelationVarName="relationArticlesArticleRatings1" msprop:Generator_UserParentTable="ArticleArticleTypeUserID" />
      <msdata:Relationship name="ArticleArticleTag1" msdata:parent="ArticleArticleTypeUserID" msdata:child="ArticleTag" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="ArticleTag" msprop:Generator_ChildPropName="GetArticleTagRows" msprop:Generator_UserRelationName="ArticleArticleTag1" msprop:Generator_ParentPropName="ArticleArticleTypeUserIDRow" msprop:Generator_RelationVarName="relationArticleArticleTag1" msprop:Generator_UserParentTable="ArticleArticleTypeUserID" />
      <msdata:Relationship name="ArticlesBookmarkArticles1" msdata:parent="ArticleArticleTypeUserID" msdata:child="BookmarkArticle" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="BookmarkArticle" msprop:Generator_ChildPropName="GetBookmarkArticleRows" msprop:Generator_UserRelationName="ArticlesBookmarkArticles1" msprop:Generator_ParentPropName="ArticleArticleTypeUserIDRow" msprop:Generator_RelationVarName="relationArticlesBookmarkArticles1" msprop:Generator_UserParentTable="ArticleArticleTypeUserID" />
      <msdata:Relationship name="ArticlesComments1" msdata:parent="ArticleArticleTypeUserID" msdata:child="Comment" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="Comment" msprop:Generator_ChildPropName="GetCommentRows" msprop:Generator_UserRelationName="ArticlesComments1" msprop:Generator_ParentPropName="ArticleArticleTypeUserIDRow" msprop:Generator_RelationVarName="relationArticlesComments1" msprop:Generator_UserParentTable="ArticleArticleTypeUserID" />
      <msdata:Relationship name="ArticlesSteps1" msdata:parent="ArticleArticleTypeUserID" msdata:child="Step" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="Step" msprop:Generator_ChildPropName="GetStepRows" msprop:Generator_UserRelationName="ArticlesSteps1" msprop:Generator_ParentPropName="ArticleArticleTypeUserIDRow" msprop:Generator_RelationVarName="relationArticlesSteps1" msprop:Generator_UserParentTable="ArticleArticleTypeUserID" />
      <msdata:Relationship name="VehicleModelTypesArticles1" msdata:parent="VehicleModelsVehicleModelID" msdata:child="Article" msdata:parentkey="VehicleModelTypeID" msdata:childkey="VehicleModelTypeID" msprop:Generator_UserChildTable="Article" msprop:Generator_ChildPropName="GetArticleRows" msprop:Generator_UserRelationName="VehicleModelTypesArticles1" msprop:Generator_ParentPropName="VehicleModelsVehicleModelIDRow" msprop:Generator_RelationVarName="relationVehicleModelTypesArticles1" msprop:Generator_UserParentTable="VehicleModelsVehicleModelID" />
      <msdata:Relationship name="VehicleModelTypeVehicleModelTypeYear1" msdata:parent="VehicleModelsVehicleModelID" msdata:child="VehicleModelTypeYear" msdata:parentkey="VehicleModelTypeID" msdata:childkey="VehicleModelTypeID" msprop:Generator_UserChildTable="VehicleModelTypeYear" msprop:Generator_ChildPropName="GetVehicleModelTypeYearRows" msprop:Generator_UserRelationName="VehicleModelTypeVehicleModelTypeYear1" msprop:Generator_ParentPropName="VehicleModelsVehicleModelIDRow" msprop:Generator_RelationVarName="relationVehicleModelTypeVehicleModelTypeYear1" msprop:Generator_UserParentTable="VehicleModelsVehicleModelID" />
      <msdata:Relationship name="VehicleModelsArticles1" msdata:parent="VehicleModelsVehicleModelID" msdata:child="Article" msdata:parentkey="VehicleModelID" msdata:childkey="VehicleModelID" msprop:Generator_UserChildTable="Article" msprop:Generator_ChildPropName="GetArticleRowsByVehicleModelsArticles1" msprop:Generator_UserRelationName="VehicleModelsArticles1" msprop:Generator_ParentPropName="VehicleModelsVehicleModelIDRowByVehicleModelsArticles1" msprop:Generator_RelationVarName="relationVehicleModelsArticles1" msprop:Generator_UserParentTable="VehicleModelsVehicleModelID" />
      <msdata:Relationship name="ArticleTypesArticles1" msdata:parent="ArticleType" msdata:child="GetUserArticles" msdata:parentkey="ArticleTypeID" msdata:childkey="ArticleTypeID" msprop:Generator_UserChildTable="GetUserArticles" msprop:Generator_ChildPropName="GetGetUserArticlesRows" msprop:Generator_UserRelationName="ArticleTypesArticles1" msprop:Generator_ParentPropName="ArticleTypeRow" msprop:Generator_RelationVarName="relationArticleTypesArticles1" msprop:Generator_UserParentTable="ArticleType" />
      <msdata:Relationship name="ArticlesArticleRatings2" msdata:parent="GetUserArticles" msdata:child="ArticleRating" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="ArticleRating" msprop:Generator_ChildPropName="GetArticleRatingRows" msprop:Generator_UserRelationName="ArticlesArticleRatings2" msprop:Generator_ParentPropName="GetUserArticlesRow" msprop:Generator_RelationVarName="relationArticlesArticleRatings2" msprop:Generator_UserParentTable="GetUserArticles" />
      <msdata:Relationship name="ArticleArticleTag2" msdata:parent="GetUserArticles" msdata:child="ArticleTag" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="ArticleTag" msprop:Generator_ChildPropName="GetArticleTagRows" msprop:Generator_UserRelationName="ArticleArticleTag2" msprop:Generator_ParentPropName="GetUserArticlesRow" msprop:Generator_RelationVarName="relationArticleArticleTag2" msprop:Generator_UserParentTable="GetUserArticles" />
      <msdata:Relationship name="ArticlesBookmarkArticles2" msdata:parent="GetUserArticles" msdata:child="BookmarkArticle" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="BookmarkArticle" msprop:Generator_ChildPropName="GetBookmarkArticleRows" msprop:Generator_UserRelationName="ArticlesBookmarkArticles2" msprop:Generator_ParentPropName="GetUserArticlesRow" msprop:Generator_RelationVarName="relationArticlesBookmarkArticles2" msprop:Generator_UserParentTable="GetUserArticles" />
      <msdata:Relationship name="ArticlesComments2" msdata:parent="GetUserArticles" msdata:child="Comment" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="Comment" msprop:Generator_ChildPropName="GetCommentRows" msprop:Generator_UserRelationName="ArticlesComments2" msprop:Generator_ParentPropName="GetUserArticlesRow" msprop:Generator_RelationVarName="relationArticlesComments2" msprop:Generator_UserParentTable="GetUserArticles" />
      <msdata:Relationship name="ArticlesSteps2" msdata:parent="GetUserArticles" msdata:child="Step" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="Step" msprop:Generator_ChildPropName="GetStepRows" msprop:Generator_UserRelationName="ArticlesSteps2" msprop:Generator_ParentPropName="GetUserArticlesRow" msprop:Generator_RelationVarName="relationArticlesSteps2" msprop:Generator_UserParentTable="GetUserArticles" />
      <msdata:Relationship name="ArticlesArticleRatings3" msdata:parent="GetArticleByVehicleDetails" msdata:child="ArticleRating" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="ArticleRating" msprop:Generator_ChildPropName="GetArticleRatingRows" msprop:Generator_UserRelationName="ArticlesArticleRatings3" msprop:Generator_ParentPropName="GetArticleByVehicleDetailsRow" msprop:Generator_RelationVarName="relationArticlesArticleRatings3" msprop:Generator_UserParentTable="GetArticleByVehicleDetails" />
      <msdata:Relationship name="ArticleArticleTag3" msdata:parent="GetArticleByVehicleDetails" msdata:child="ArticleTag" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="ArticleTag" msprop:Generator_ChildPropName="GetArticleTagRows" msprop:Generator_UserRelationName="ArticleArticleTag3" msprop:Generator_ParentPropName="GetArticleByVehicleDetailsRow" msprop:Generator_RelationVarName="relationArticleArticleTag3" msprop:Generator_UserParentTable="GetArticleByVehicleDetails" />
      <msdata:Relationship name="ArticlesBookmarkArticles3" msdata:parent="GetArticleByVehicleDetails" msdata:child="BookmarkArticle" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="BookmarkArticle" msprop:Generator_ChildPropName="GetBookmarkArticleRows" msprop:Generator_UserRelationName="ArticlesBookmarkArticles3" msprop:Generator_ParentPropName="GetArticleByVehicleDetailsRow" msprop:Generator_RelationVarName="relationArticlesBookmarkArticles3" msprop:Generator_UserParentTable="GetArticleByVehicleDetails" />
      <msdata:Relationship name="ArticlesComments3" msdata:parent="GetArticleByVehicleDetails" msdata:child="Comment" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="Comment" msprop:Generator_ChildPropName="GetCommentRows" msprop:Generator_UserRelationName="ArticlesComments3" msprop:Generator_ParentPropName="GetArticleByVehicleDetailsRow" msprop:Generator_RelationVarName="relationArticlesComments3" msprop:Generator_UserParentTable="GetArticleByVehicleDetails" />
      <msdata:Relationship name="ArticlesSteps3" msdata:parent="GetArticleByVehicleDetails" msdata:child="Step" msdata:parentkey="ArticleID" msdata:childkey="ArticleID" msprop:Generator_UserChildTable="Step" msprop:Generator_ChildPropName="GetStepRows" msprop:Generator_UserRelationName="ArticlesSteps3" msprop:Generator_ParentPropName="GetArticleByVehicleDetailsRow" msprop:Generator_RelationVarName="relationArticlesSteps3" msprop:Generator_UserParentTable="GetArticleByVehicleDetails" />
      <msdata:Relationship name="ArticleTypesArticles2" msdata:parent="GetArticleTypeArticleID" msdata:child="Article" msdata:parentkey="ArticleTypeID" msdata:childkey="ArticleTypeID" msprop:Generator_UserChildTable="Article" msprop:Generator_ChildPropName="GetArticleRows" msprop:Generator_UserRelationName="ArticleTypesArticles2" msprop:Generator_ParentPropName="GetArticleTypeArticleIDRow" msprop:Generator_RelationVarName="relationArticleTypesArticles2" msprop:Generator_UserParentTable="GetArticleTypeArticleID" />
      <msdata:Relationship name="UsersBookmarkArticles1" msdata:parent="GetUserArticleID" msdata:child="BookmarkArticle" msdata:parentkey="UserID" msdata:childkey="UserID" msprop:Generator_UserChildTable="BookmarkArticle" msprop:Generator_ChildPropName="GetBookmarkArticleRows" msprop:Generator_UserRelationName="UsersBookmarkArticles1" msprop:Generator_RelationVarName="relationUsersBookmarkArticles1" msprop:Generator_UserParentTable="GetUserArticleID" msprop:Generator_ParentPropName="GetUserArticleIDRow" />
      <msdata:Relationship name="UsersComments1" msdata:parent="GetUserArticleID" msdata:child="Comment" msdata:parentkey="UserID" msdata:childkey="UserID" msprop:Generator_UserChildTable="Comment" msprop:Generator_ChildPropName="GetCommentRows" msprop:Generator_UserRelationName="UsersComments1" msprop:Generator_RelationVarName="relationUsersComments1" msprop:Generator_UserParentTable="GetUserArticleID" msprop:Generator_ParentPropName="GetUserArticleIDRow" />
      <msdata:Relationship name="VehicleModelTypesArticles2" msdata:parent="GetVehicleDetailsArticleID" msdata:child="Article" msdata:parentkey="VehicleModelTypeID" msdata:childkey="VehicleModelTypeID" msprop:Generator_UserChildTable="Article" msprop:Generator_ChildPropName="GetArticleRows" msprop:Generator_UserRelationName="VehicleModelTypesArticles2" msprop:Generator_ParentPropName="GetVehicleDetailsArticleIDRow" msprop:Generator_RelationVarName="relationVehicleModelTypesArticles2" msprop:Generator_UserParentTable="GetVehicleDetailsArticleID" />
      <msdata:Relationship name="VehicleModelTypeVehicleModelTypeYear2" msdata:parent="GetVehicleDetailsArticleID" msdata:child="VehicleModelTypeYear" msdata:parentkey="VehicleModelTypeID" msdata:childkey="VehicleModelTypeID" msprop:Generator_UserChildTable="VehicleModelTypeYear" msprop:Generator_ChildPropName="GetVehicleModelTypeYearRows" msprop:Generator_UserRelationName="VehicleModelTypeVehicleModelTypeYear2" msprop:Generator_ParentPropName="GetVehicleDetailsArticleIDRow" msprop:Generator_RelationVarName="relationVehicleModelTypeVehicleModelTypeYear2" msprop:Generator_UserParentTable="GetVehicleDetailsArticleID" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>